Globally change print settings for several worksheets at the same
 

I want to change the print settings for several worksheets that are in the
same workbook with one command. Is this possible?

Globally change print settings for several worksheets at the same
 

Yes, I do it all the time. However, be careful if you need independent
modifications and make sure you don't apply those to all of them. Click
once on the name for the first worksheet to select it, then hold down
Shift and select the last worksheet to which you need to apply the
modifications. This will select the first, last and everything in
between. If you need to take some out, hold down Ctrl then click on the
worksheet that you need to take out. Note that Ctrl + click can be used
to select/deselect multiple worksheets individually.


--
ArenaNinja
------------------------------------------------------------------------
ArenaNinja's Profile: http://www.excelforum.com/member.php...o&userid=33624
View this thread: http://www.excelforum.com/showthread...hreadid=547914