duplex

Hi everyone, I have been working with this basic macro the last few days, and you guys have been amazing. I just have one last question on this. It will print the first two sheets, but I can't get it to print them Duplex. I tried adjusting the page settings and printer setting, but this...

I cannot figure out how to duplex print 1x3 pages for each worksheet in my workbook. When I select all tabs and each one is formatted to print duplex, on the last of the three pages, I get the next worksheet's first page. Thanks very much.

Sorry if this question has been asked before. am using excel97. I have dozens of worksheets all different, I want to be able to print all these duplex The sheets have all previously been set up as 1 page containing only the ranges required. Odd pages should change but even pages should remain...

Is there any way to set the 'Print both sides' option in the new 'print' screen in Word 2010 using vba? I can't alter the printer settings using vba/api as I don't have admin access (the printers are networked)