Printing different work sheets in colour when the default is b&W

W

Wavey Davey

if you have a multiple worksheet document and the printer defauls to mono and
duplex but you wish the whole document to be printed in colour and simplex is
the only way of achieving this to chage the printer setup on each and every
worksheet?

thank you very much for any guidance.
 
G

Gav123

Hi,

Maybe if you group all the worksheets (click the first worksheet tab, hold
shift key and click on the last worksheet tab) then you can set your printer
settings. Remeber to ungroup when finished.

Hope this helps,

Gav
 
W

Wavey Davey

unfortunatly that doesn't work, the first page/worksheet will come out
correctly then all the subsequent ones will be mono duplex etc.
thanks anyway
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplex Printing Macro 0
Problem printing all worksheets in colour 1
Cannot print in colour in Excel 2003 1
How can I print 1 page in b/w & another in colour from a document? 2
How do I print a whole excel file in colour when the default is mo 11
How can I print different sections of the one Word document to twodifferent printers? 1
Colour Printing with Multiple Worksheets 0
Need Macro to Dictate Duplex Printing 0

Top