Print on both sides of paper from two worksheets

S

SC in Texas

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.
Thanks
 
S

SC in Texas

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
 
B

basic

I also was looking for a solution to this and TomPl is correct, follow his
directions and it should work.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top