hi
in printing, basicly all excel does is send the data. excel has some
standards formats but not all primarily due to the large varity of printers
available on the market.
the rest is done by the printer. do you have access to a printer that prints
duplex. if not then excel(VB) cannot do what your printer is incapable of
doing.
filepage setup options button.
this will call up the settings of your default printer. if you printer has
duplex printing, you can set it up here. otherwise sorry. you'll have to do
it the old fashion way. print ever other sheet then flip the stack over.
see this site for code on printed odd/even pages.
http://www.rondebruin.nl/print.htm#odd

regards
FSt1


regards
FSt1
"QuietMan" wrote:

Does anyone know the vba code to set the printer to print duplex.

Also to have it print duplex when the data being printed is on more than one
tab

Thanks
--
Helping Is always a good thing