A general question -

How can I print multiple Worksheets out of a Workbook with a single print
command, without printing the entire Workbook...

Simple example which does not reflect the real condition:
Workbook A.xls contains Sheet1, Sheet2, Sheet3, Sheet4...

I would like to print Sheet 2 and Sheet 4 with a single print command
without printing the entire Workbook...
--
Thanks in advance for the assistance-
Joe Mac

You can activate multiple worksheets by holding down the CNTL button and
selecting the multiple sheet tabs. Then when you pring you can prin Active
Sheet(s).

"Joe Mac" wrote:

A general question -

How can I print multiple Worksheets out of a Workbook with a single print
command, without printing the entire Workbook...

Simple example which does not reflect the real condition:
Workbook A.xls contains Sheet1, Sheet2, Sheet3, Sheet4...

I would like to print Sheet 2 and Sheet 4 with a single print command
without printing the entire Workbook...
--
Thanks in advance for the assistance-
Joe Mac

Thank you Joel, this worked well and raised the next question...

When I print (preview & print) the now active Worksheets, I receive the
Custom Footer as "1 of 2" and 2 of 2" presumably because Excel is
constructing a backend spool to the printer... each Worksheet has a
consistent Customer Footer designed as "&[Page] of &[Pages]" to show as "2 of
4" and "4 of 4" from a full Workbook print (keeping with the same example)...


Can Excel retain the Customer Footer consistent with the full Workbook, so
that when I select Sheet 2 and Sheet4 the Customer Footer will show as "2 of
4" and "4 of 4"

Thanks again for the assistance-
Joe
--

Joe Mac


"Joel" wrote:

You can activate multiple worksheets by holding down the CNTL button and
selecting the multiple sheet tabs. Then when you pring you can prin Active
Sheet(s).

"Joe Mac" wrote:

A general question -

How can I print multiple Worksheets out of a Workbook with a single print
command, without printing the entire Workbook...

Simple example which does not reflect the real condition:
Workbook A.xls contains Sheet1, Sheet2, Sheet3, Sheet4...

I would like to print Sheet 2 and Sheet 4 with a single print command
without printing the entire Workbook...
--
Thanks in advance for the assistance-
Joe Mac

I don't think so. What you want works with Word, not with excel. I usually
select entire Workbook and then select the Start Page and End Page.
Sometimes I have to do this multiple times.

"Joe Mac" wrote:

Thank you Joel, this worked well and raised the next question...

When I print (preview & print) the now active Worksheets, I receive the
Custom Footer as "1 of 2" and 2 of 2" presumably because Excel is
constructing a backend spool to the printer... each Worksheet has a
consistent Customer Footer designed as "&[Page] of &[Pages]" to show as "2 of
4" and "4 of 4" from a full Workbook print (keeping with the same example)...


Can Excel retain the Customer Footer consistent with the full Workbook, so
that when I select Sheet 2 and Sheet4 the Customer Footer will show as "2 of
4" and "4 of 4"

Thanks again for the assistance-
Joe
--

Joe Mac


"Joel" wrote:

You can activate multiple worksheets by holding down the CNTL button and
selecting the multiple sheet tabs. Then when you pring you can prin Active
Sheet(s).

"Joe Mac" wrote:

A general question -

How can I print multiple Worksheets out of a Workbook with a single print
command, without printing the entire Workbook...

Simple example which does not reflect the real condition:
Workbook A.xls contains Sheet1, Sheet2, Sheet3, Sheet4...

I would like to print Sheet 2 and Sheet 4 with a single print command
without printing the entire Workbook...
--
Thanks in advance for the assistance-
Joe Mac