View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
I Rygert
 
Posts: n/a
Default Print setup of a complete workbook

I want to print out all sheets or a selection of sheets in my workbook
without having to setup all the printerinformation sheet by sheet.
I make my printouts by a network printer with different trays, colour or
b/w, staples...
For example, i want to print 10 sheets with the same printsetup. Today i
have to walk through every sheet and make a setup for each one.

Is there anyway i can make a setup for the whole workbook (or selected
sheets) at one time?
Grateful for your answers...