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

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


On May 7, 8:27 am, "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

Thanks Susan,
I always forget about the macro thing :)

-BWT

"Susan" wrote in message
oups.com...
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


On May 7, 8:27 am, "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

:D
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


On May 7, 9:38 am, "BurntWithTime" wrote:
Thanks Susan,
I always forget about the macro thing :)

-BWT

"Susan" wrote in message

oups.com...



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

On May 7, 8:27 am, "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- Hide quoted text -

- Show quoted text -

Hello,

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

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

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