View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
TomPl TomPl is offline
external usenet poster
 
Posts: 342
Default Print on both sides of paper from two worksheets

If you select more that one sheet simultaneously, the multiple sheets will be
printed as one job. Code like that below will accomplish the task:

Sheets(Array("Sheet1, "Sheet2")).Printout

Best of luck.

Tom

"SC in Texas" wrote:

I am hoping that there is a way to do the print commands in code on a command
button that will make excel not treet the sheets as separate documents but
treat them as one in the print command.
With a printer that has to manually be reloaded for the second page it works
great but for the automatic ones it treats each sheet as separate documents
and not the workbook as a single document print job.
Thanks for the reply. It is good to know I am not the only one trying to
deal with this. I am trying to set this up as a template for others to use
and the multiple steps in your solution would work great for me but not for
them.
Thanks,
Steve
--
SC from Lubbock, Texas


"MyVeryOwnSelf" wrote:

How do I get a printer that will print on both sides of the paper
automatically to do so from two worksheets in the workbook. If I have
two pages on the same worksheet it works fine or if I print to a
printer that requires the paper to be changed manually it works fine.
But it the printer handles the paper automatically it gives me two
sheets with the back side blank.


This problem annoys me too. Excel seems to treat sheets as separate
documents.

The following works for me, but it's awkward.

Print each worksheet using the "Microsoft Office Document Image Writer."
This produces an ".mdi" file for each worksheet. With both files open, it's
possible to copy pages from one into the other, merging the two into one
mdi file. Then the merged file can be printed.

For somebody doing this a lot, it might be helpful to use third-party
software like:
http://www.fineprint.com/products/fineprint/index.html