Nia

Some print setup features can be set with the worksheets "grouped".

Right-click on a sheet tab and "select all sheets"

Then set up the active sheet and all sheets will receive same setup including
printer choice.

EXCEPTIONS..............

Print Range cannot be set on grouped sheets.

Rows to repeat at top cannot be set on grouped sheets.

To set these two items on all sheets would require VBA code.

If interested in some code, post back.


Gord Dibben MS Excel MVP

On Tue, 19 Dec 2006 12:55:00 -0800, "Nia" wrote:

We have a new networked printer in our office and now we are having a problem
printing entire workbooks in color. It will not apply the default print
settings to all pages if it was printed on another printer first. The first
page will print in color but it does not appear to apply those settings to
each of the pages in the workbook. It looks like we have to go to each page
and change the printer settings to the new printer then re-save the doc so
the setting stay. Is there a way to apply printer settings to all pages in
the workbook automatically instead of having to go to each sheet then re-save
the document??? Any help is appreciated...Thanks

Gord Dibben MS Excel MVP