Page Numbers

[Guest]

i have a workbook with 40 worksheets, each worksheet is one page. I want to
print all 40 with a page number. I kno wI can select them all, go print
preview and then print with the page numbers. But this workbook goues to many
people. I want to use a macro that will print the 40 pages numbered 1-40.

Thanks,
Tom

 

[Anne Troy]

This should occur automatically (and by default). If you are choosing to
print your entire workbook, and if you select all sheets, go to File-->Page
setup, and make sure page number is Auto.

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com