In our company we have set the print server drivers for color printers to print in black and white (it is more economical that way).
That means when you need to print an Excel worksheet in color, you just need to change the printer properties in the Print windows and choose color as quality. That’s ok, but when we choose to print the whole document in color, it is only the last selected worksheet which prints in color. In order to print all in color, we need to go in each and every worksheet and change the b/w to color settings.
We think that Excel takes the b/w info from the driver on the print server.
Does anybody know how to tell Excel to print all worksheets in color (it probably means accessing the driver) ?