Print selected pages from multiple worksheets

[Tigerxxx]

When I go to file print, I can select different pages from one worksheet but
how can I select different pages from different worksheets in the same
workbook?
Example-
I have 5 worksheets in a workbook. Each worksheet has 10 pages configured
for printing.
How can I select-
Page 1 & 7 from worksheet 1
Pages 2 & 5 from worksheet 3
Pages 4 & 9 from worksheet 5
....all to print at once?

Thank you

 

[tedmi]

You can do this with the Report Manager add-in for Excel. Unfortunately, MS
stopped providing RM after Excel 2002 (in Office XP). Fortunately, that
version of RM can be used with later versions of Excelm including 2007.
See http://support.microsoft.com/kb/873209/en-us

 

[Tigerxxx]

Thanks Tedmi.
I tried downloading, but they do not seem to add in Excel 2003.
I was wondering if a Macro could be available which one of the macro experts
may be able to provide.

Thanks again.

 

[tedmi]

For 2003, DO NOT execute the download. Instead, use WinZip to extract
RptMgr.xla and then copy it to the location specified in the instructions
given here:
http://support.microsoft.com/kb/873209/en-us

 

[Tigerxxx]

Thanks Tedmi.
This seems to be working, I will just have to get used to it.
If you do find a macro wherein you can select page numbers, please let me
know.

Thanks