Thanks Eric - that's exactly what I was looking for!

>see http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q194/6/11.asp&NoWebContent=1
>
>
>>Hi,
>>
>>I've been doing a fair bit of work recently using VB6 to create Excel spreadsheets for reporting purposes. Now, I've been asked to programatically add macro code the spreadsheet to facilitate printing each of the tabs. Can this be done (i.e. adding macro code programatically)?