View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rafat
 
Posts: n/a
Default How to print a selected number of sheets?

I have an excel workbook where everytime the option of print entire workbook
from the print menu is selected, the last two sheets should not print, and
the total page numbers should get adjusted in the header accordignly aswell.

forexample: I have 14 sheets. only first 12 should print when the option of
print entire workbook is selected, and the page numbering should be 1 of 12,
2 of 12..............

Thanks,