Gord

I knew there was a reason you were always watching this site. <bg Thanks
for the bump in to right direction, I did not realize all the print settings
that this would effect!!!!

The one commodity that we have in the greatest abundance is ignorance, and I
wonder if we will ever get different, more abundant, commodity.

Thanks again

Mike Rogers

"Gord Dibben" wrote:

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 08:14:04 -0800, Mike Rogers
<Mike060349@NoxSpamxAOLDOTcom wrote:

Laura

If I already had the header/footer set on one worksheet, in pre xl2007 (it
may work on 2007 I just don't speak 07 yet) I would "Group" all sheets with
the one with the header/footer as the ative one. I would goto viewheader and
footerI would select "ok" and let xl do the rest. It will copy the
header/footer to all worksheets. As Sheleoo said you can also modify, or
build from scratch, the header/footer at this time and it will hit all
worksheets.

Mike Rogers

"Laura" wrote:

Is there a way to copy a header into all worksheets in a file automatically