We have one spreadsheet that has about 15 tabs. I would like to add to my
macro some code that would print some of these spreadsheets duplex and some
simplex. create a macro to print these 15, with some being printing simplex
and others printing duplex. The printer is set up to do duplex as default.
I don't want the user to have to change printer properties before printing
each sheet. So is there a function I can put in my macro like
"printeroptions.duplex.enable" and "printeroptions.duplex.disable" that I
would put right before "ActiveWorkbook.ActiveSheet.PrintOut" that would allow
me to switch like this? On the user's side, all I want him to have to do is
start the macro.

Thank you,
jerrybdot