many printer options cannot be set with VBA, because the printer
options are under the control of Windows, not VBA. if you look in the
objects browser & search for "print" you can see all the things that
VBA can do with this operation, but you'll note there are things you
can't do by VBA.
sorry!
susan




On Oct 13, 9:53*pm, Rita wrote:
I am trying to "uncheck" the collate box on the print options for Excel 2007
and then save the worksheet. * I would like it to work like this always.. *
When I retrieve the worksheet again and print, it always collates.

Where do I set the default print settings for Excel 2007? *

Example: *We have a new Konica Bizhub 320 and if you choose 4 copies it
waits a second between copies if the collate box is checked. *If the box is
unchecked, the printer immediately prints out 4 copies. *Our old copier never
did this, so I need to change the default print settings in Excel and I think
it will function properly.

I have tried "print" "properties" and uncheck "collate", I save it and when
I bring it back up, it still tries to collate.

Thanks for any help you can give.