Print selected pages from multiple worksheets
 

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

Print selected pages from multiple worksheets
 

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
--
TedMi

Print selected pages from multiple worksheets
 

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" wrote:

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
--
TedMi

Print selected pages from multiple worksheets
 

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 he
http://support.microsoft.com/kb/873209/en-us
--
TedMi

Print selected pages from multiple worksheets
 

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

"tedmi" wrote:

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 he
http://support.microsoft.com/kb/873209/en-us
--
TedMi