Change Print Quality for entire workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dnguyen411 - 15 Nov 2006 02:35 GMT

Is there a way to change the Print Quality for all tabs in a workbook without
going to each individual tab and changing the setting there? I have a 70 tab
workbook where chaning the print setup individuality would be time
prohibitive.

Reply to this Message

Paul B - 15 Nov 2006 11:51 GMT

dnguyen411, give this a try,

With the sheet that has the correct settings active, right-click on the
sheet tab and select "Select All Sheets", then use File/Page Setup and
immediately click OK (don't change anything). Click on some other worksheet
to get you out of "Group" mode now all sheets should have the same page
settings!

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> Is there a way to change the Print Quality for all tabs in a workbook without
> going to each individual tab and changing the setting there? I have a 70 tab
> workbook where chaning the print setup individuality would be time
> prohibitive.

Reply to this Message