Hi

There are loads of page setup parameters that can be set in VBA
If you start a macro recording on a new workbook, select PageSetup from the
File menu, change one of the settings, stop the macro recording.
Then look at the code.

Dave.

"CFD" wrote in message
...

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