Thank you very much. This was very helpful. I ended up just making two pages
on one worksheet and printing two sided. It works! That way it is also saved
with those settings. Thanks for the help!

"Bryan Hessey" wrote:


Because each worksheet is it's own separate print (with it's own 'Set
Print Area' etc) you cannot have them considered for duplexing
together.

Two (or more) worksheets can be duplexed by printing to Acrobat
Distiller and printing the resultant .pdf file to the duplex printer,
this would be the 'quick-and-easy' method for you, printing once from
Excel and copies = 100 from Adobe (if you have Adobe Acrobat or
similar program).


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390586