View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jackie Osterman
 
Posts: n/a
Default Printing Workbook

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

--