Good point
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
My usual add-on<g

One caveat with this method.

ALL print settings except for print range and rows to repeat at top will
be
changed to that of the activesheet.

So, if you wish to maintain different margins or other sheet settings for
each sheet, do not use this method.


Gord Dibben MS Excel MVP

On Wed, 4 Mar 2009 16:40:04 -0400, "Bernard Liengme"
wrote:

Group the sheets: click on the tab of Sheet1; hold SHIFT; click on tab of
last sheet.
Note how all sheets tabs have the same shading/colour when grouped
File | PageSetUp and add headers/footers
Ungroup sheets by clicking an sheet tab
best wishes