printing multiple worksheets and changing printer defaults

[pzps29]

Hi
sorry if this has been asked before but here goes:-

we have just refreshed our entire printer fleet to Xerox printers and as part of the project we have selected all defaults to B&W and duplex.

On a multi sheet excel file, If we click print then choose entire workbook
and then change the print options to colour, it prints the only first worksheet in
colour, and all the others in mono. i have read that excel treats each worksheet separately and does not cascade the changes made made in the first worksheet even if all sheets have been selected

How can I get them all to print in colour?

we can set up another printer and change the defauts to colour but we dont want to go down that road and have 2 printers installed for each model.

is there any code out there can will/ can change the properties of the first worksheet and cascade this throughout the workbook.

we use XP and W7 workstations and office 2003, 2007 and 2010.
by the end of the year all workstations will be W7 and Office 2010

regards
Gavin

 

[HunterN]

This is exactly what I am trying to do. Is there an answer to this? Did you ever figure it out?

Thanks,
Nancy

 

[pzps29]

Hi Stacey, the only way i found was this.
If you are wanting to print a workbook out with multiple worksheets single or double sided and colour and you select single sided and colour it will only print the first page single and colour and the rest 2 sided and black,, this is because Excel treats every worksheet in a workbook as a separate job.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
to print this out, please follow the notes below<o></o>
<o> </o>
select the desired printer<o></o>
select entire workbook<o></o>
select the printer properties<o></o>
in the printer properties <o></o>
select either 1 sided or 2 sided from the paper/ output tab<o></o>
select colour from the colour options tab<o></o>
<o> </o>
In the bottom right of the screen under Saved Settings select Save as Microsoft Excel Defaults<o></o>
ok <o></o>
and ok to print the document <o></o>

regards
Gavin