Macro that prints multiple sheets and maintains respective sheet page numbering.

[dodgerdawg]

Here's the problem: I have a workbook with multiple sheets in it. Each sheet contains multiple pages when printed out. Also, each sheet has page number separate from the other sheets. For example: 'Sheet 1' has 5 pages, so it is number "Page 1 of 5", "Page 2 of 5", etc. Each additional sheet has its own unique page numbers.

When I print off multiple sheets at a time, I want each sheet to maintain its unique page numbering. The problem is though that when I either group specific sheets and select 'Print' or if I select 'Print Workbook' from the print options, the unique page numbering for each sheet disappears and all the documents printed are combined into one page numbering sequence.

Is there an option I'm not aware of that would solve this problem? If not, how could I write a macro that would solve this problem?

Thanks.