From: Harry Hornet on
I have a number of colour network printers that are set to default to black
and white and to duplex.
I know how to change the printing preferences locally when I want to print
in colour but I have an Excel 2007 workbook that I want to print in colour
and single sided.
If I set the printing preferences to print colour and non duplex, when I
print the whole workbook only the first worksheet seems to come out in
colour. The rest of the sheets are printed in black and white and back to
back.
How can I make the entire workbook print according to my preferences?
From: Harry Hornet on
This is the first time I have posted a question and no-one has replied! Have
I stumped you all or should I be in another discussion group??

"Harry Hornet" wrote:

> I have a number of colour network printers that are set to default to black
> and white and to duplex.
> I know how to change the printing preferences locally when I want to print
> in colour but I have an Excel 2007 workbook that I want to print in colour
> and single sided.
> If I set the printing preferences to print colour and non duplex, when I
> print the whole workbook only the first worksheet seems to come out in
> colour. The rest of the sheets are printed in black and white and back to
> back.
> How can I make the entire workbook print according to my preferences?