Chris

Print options are sheet-related, not book-related.

First group the sheets by right-click on the first sheet tab and "select all
sheets".

FilePage SetupSheet. Uncheck "black and white".

Ungroup the sheets by right-click and "ungroup sheets"

Now FilePrintEntire workbook.


Gord Dibben MS Excel MVP

On Wed, 11 Jan 2006 08:45:03 -0800, "Chris C" <Chris
wrote:

Our printer defaults are set to print all docs in monochrome.

On a multi sheet excel file, If I click print then choose entire workbook
and then change my print options to colour, it prints the first worksheet in
colour, and all the others in mono.

How can I get them all to print in colour?

Thanks