Printing Workbook

[Jackie Osterman]

I would like to be able to print an entire workbook with the pages of the
individual sheets numbered per the number of pages in that sheet.

For example, Sheet 1 has 5 pages I would like them numbered page 1 of 5,
etc, Sheet 2 has 6 pages-I would like them numbered 1 of 6, etc.----as I
print the entire workbook.

Can this be done. As I have it set up now, the entire workbook has 45
pages. I can print the individual sheets and get the results I want, BUT,
as I print the entire workbook, the pages are numbered 1 of 45, etc.

Thanks for your help.
Jackie

 

[Dave Peterson]

Maybe you could use a macro:

Option Explicit
Sub testme()
Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
wks.PrintOut preview:=True
Next wks
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm