Is if possible to set up two different sheets in the same workbook to print as front and back pages on a duplex printer?
Is if possible to set up two different sheets in the same workbook to print as front and back pages on a duplex printer?
Last edited by hodkd; 04-09-2009 at 03:46 PM.
yes, select both sheets , then print
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I tried that but it printed them on seperate papers just as if I printed each one seperatly.
Wouldn't you have to go into the Printer properties and change somewhere to print 2-sided... (each printer has it's own naming convention or tab the option is in... so you will have to find it)...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
if you select both sheets
then [group] should appear after workbook name then go to print preview you will see them as page 1 and 2.(as long as you have only set the print area on each sheet to one page)
make sure your printer is set to print both sides then it will do just that
I did that, picked both sheets and it said group after the name, and then when I tell it to print and set the printer to duples it prints each sheet on seperate pieces of paper.
sorry mate but it works fine on mine,home and work
Finnaly got the printer to print on both sides by choosing the second sheet first and then the first sheet and then telling the printer to print duplex.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks