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

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


"tojo107" wrote in message
...
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