View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wavey Davey[_2_] Wavey Davey[_2_] is offline
external usenet poster
 
Posts: 1
Default Printing different work sheets in colour when the default is b

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

"Gav123" wrote:

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

"Wavey Davey" wrote:

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.