Change Print Quality for entire workbook

[dnguyen411]

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.

 

[Paul B]

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!


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