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

On Mon, 7 May 2007 13:27:46 +0100, "BurntWithTime" wrote:

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