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

With Ctrl key press, click on the tabs of the sheets you want to print: this
will group your sheets and enable you to print-setup them at a time.

HTH
--
AP

"I Rygert" <I Rygert@discussions.microsoft.com> a écrit dans le message de
news:F0F1A1E2-FC6F-47C7-B93B-33EDE9CE75F0@microsoft.com...
> 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...
>