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
>
>