Thanks for your help.

The Black and White check box was not selected when I did this. It is on
the print server that we set the default to be mono, and it is within the
print settings that we change it to colour. Is there a way to apply this to
all sheets quickly without having to go into each sheet and do
file..print..properties to set each to colour before printing the workbook?

Thanks for the info it has been most helpful.

"Gord Dibben" wrote:

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