you only can with very complex api calls.
(way over George's head I'd think :)

the nobrainer workaround:
in control panel create a second printer with duplex enabled
and refer to that in your printout code.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


CFD wrote :


I know that the page setup options are specific to the printer, but I
was wondering if there is anyway to access them from VBA.

I regullarly need to overide my companies default "print duplex"
option to print single sided. To do this I have to manually go
through each worksheet and change the page setup options. It would be
fantastic if I could access these options via VBA and write a script
to automatically do it ...

Any ideas, or am I as likely to find an answer as George Bush is to
find a brain cell?