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

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

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

Chris

"Group" the sheets as per my first post.

What you do to the active sheet will be done to all in the group.


Gord

On Wed, 11 Jan 2006 23:54:02 -0800, "Chris C"
wrote:

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

With the print menu selected - Next to the "PRINTER NAME" there should
be a selection named "PROPERTIES" select it and under one of the
various tabs you should be able to select "COLOR" - my guess is that
the "PRINTER PROPERTIES box for color or monochrome, has the MONOCHROME
or box checked.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=500240

This is correct.

That is how I'm changing the print option to colour. We default this to
mono on the print server as a cost saving measure so people only print in
colour when required and not as the default.

My problem is that I can't get it to apply to all sheets in a workbook.
Just the current active sheet. Even after grouping them as Gord asked, this
still has no effect.

I'm starting to believe that this is an Excel 'feature'. We use Excel 2000,
so I'm not sure if this behaviour exists in newer versions.

Thanks for your comments.

"wjohnson" wrote:


With the print menu selected - Next to the "PRINTER NAME" there should
be a selection named "PROPERTIES" select it and under one of the
various tabs you should be able to select "COLOR" - my guess is that
the "PRINTER PROPERTIES box for color or monochrome, has the MONOCHROME
or box checked.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=500240

Gord,

Thanks again for your comments.

Unfortunately, following your instructions has no effect for me. This is
what I did.

1. Right click on Sheet 1. Select All Sheets
2. File.. Print
3. Properties
4. Change to Colour
5. Press OK.

The 3 sheets in my excel doc now print, but the first one is in colour, the
rest are not. This is even backed up by the print preview. I've tried this
on HP and Lexmark printers so It's not a driver issue. Looks like an Excel
thing. We run Excel 2000 here so maybe it doesn't do this in a later version?

Thanks


"Gord Dibben" wrote:

Chris

"Group" the sheets as per my first post.

What you do to the active sheet will be done to all in the group.


Gord

On Wed, 11 Jan 2006 23:54:02 -0800, "Chris C"
wrote:

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

Chris

Try this.........

1. Select all sheets

2. FilePage SetupSheet

3. Uncheck "black and white"

I think that's where your problem lies.


Gord

On Fri, 13 Jan 2006 00:20:03 -0800, "Chris C"
wrote:

Gord,

Thanks again for your comments.

Unfortunately, following your instructions has no effect for me. This is
what I did.

1. Right click on Sheet 1. Select All Sheets
2. File.. Print
3. Properties
4. Change to Colour
5. Press OK.

The 3 sheets in my excel doc now print, but the first one is in colour, the
rest are not. This is even backed up by the print preview. I've tried this
on HP and Lexmark printers so It's not a driver issue. Looks like an Excel
thing. We run Excel 2000 here so maybe it doesn't do this in a later version?

Thanks


"Gord Dibben" wrote:

Chris

"Group" the sheets as per my first post.

What you do to the active sheet will be done to all in the group.


Gord

On Wed, 11 Jan 2006 23:54:02 -0800, "Chris C"
wrote:

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