Duplex Printing in Excel?

[BurntWithTime]

Hi people,
I wonder if anyone could help. I have an excel file that is made up of 2
sheets. When printed I would like Sheet1 to be the front and Sheet2 to be
the back of the page. First of all, is this possible and second of all, if
so, is there any simple(ish) code that I can bind to a button on the
worksheet?

Thanks for any help,
-BWT

 

[Susan]

try using the macro recorder while you set up your printer to do back-
to-back printing & print one. it might give you some ideas that you
could attach to a button.

susan

 

[BurntWithTime]

Thanks Susan,
I always forget about the macro thing

-BWT

 

[Susan]

well, i'm not sure it will work, because sometimes the recorder
doesn't record certain things, especially when working outside of
excel (like printer settings).
susan

 

[equiangular]

Hello,

You may try to select both sheets then set duplex printing.

 

[Gord Dibben]

If your printer supports duplex you should not have a problem.

Excel does not in itself have a duplexing feature.

Run first side through then turn paper over and run second side through is the
only way Excel can do it.

See Ron de Bruin's site for code, although with only two pages I wouldn't bother
with code.

http://www.rondebruin.nl/print.htm#odd


Gord Dibben MS Excel MVP