printing multiple worksheets in excel in colour

[Krustee]

hello there,

I have an issue when printing multiple excel worksheets in colour. I'm using
Excel 2003.

The default driver setting for our printer is set to Black & White although
it can do both colour and B & W. When trying to print multiple worksheets in
a workbook if you go to the printer properties and change the setting to
colour only the first sheet prints in colour the rest comes out as B&W.

It appears that the only method for printing all worksheets in colour is to
select each worksheet individually and change its properties to colour. This
is quite frustrating if you have a large workbook.

I have tried different print setting and worksheet options of selecting all
worksheets together and grouping them or using the 'entire workbook' button.

Any advice or possibly scripts to overcome this would be appreciated.

thanks