Change default print settings Excel 2007

[Rita]

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.

 

[Susan]

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

 

[JLatham]

You probably need to set this in the printer's setup dialog rather than
trying to change it on a per-use basis in Excel.

Click the windows task bar [Start Button] and in the Settings flyout, choose
Printers and Faxes. Right-click on the specific printer and choose
[Properties]. Set the collate option from that dialog and see if it doesn't
help.

 

[BSc Chem Eng Rick]

Rita,

You need to change the default settings for the printer, not Excel. Go to
Printers & Faxes in your control Panel. Find the printer you want, right
click and select properties. Now uncheck "Collate" and click OK. These are
now saved as your default print settings. Note that none of your documents
will collate once you do this.

If this helps please click "Yes"
<><><><><><><><><><>

 

[Atishoo]

these are settings for your printer not specific settings in excell.
go to control pannel - printers and faxes - selct your printer and change
the settings there.