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?


--
CFD


------------------------------------------------------------------------
CFD's Profile: http://www.excelforum.com/member.php...o&userid=27306
View this thread: http://www.excelforum.com/showthread...hreadid=507939