Header & Footer

[vikesh]

I often get files from other users who do not maintain the headers
footers properly.

Is it possible that we adjust the Header and/or Footer for on
worksheet and the Header and/or Footer is automaticcaly updated for al
other worksheets in the same file. It would save a lot of time, sinc
otherwise you have to go to all the worksheets and make the change
manually.

Thanks in advance.

PS: Using Excel 200

 

[Ron de Bruin]

Hi

Group the sheets first(right click on a sheet tab and choose"Select all sheets")
Change the header in File Page Setup
Ungroup the sheets

 

[vikesh]

had i idea in mind:

if we create a macro that copies the Header & footer of one sheet an
paste/updates the Headers & footers of other worksheets -then th
problem could be solved.

Is it feasible ?? since i don't know how to write macro in VB

 

[Dave Peterson]

You could record a macro when you do it once and run it for each sheet.

But Ron's suggestion looks a lot easier to me.

http://groups.google.com/groups?selm=#[email protected]

 

[On Film]

John Walkenback's PUP tools includes ability to copy and paste headers
and footers. www.j-walk.com I have no financial interest in the
product, but it is the most productive add-in for Excel that I have
discovered.

Mike

 

[Mark Simmons]

Just getting started on this kind of thing (a newbee to excel), but I tried
out this code and it changes the header and footer in all the sheets in this
workbook.
Sheet1 has a custom footer and header "centered".
There are also Left and RightFooter properties available.

For Each Sheet In Sheets
PageSetup.CenterFooter = Sheet1.PageSetup.CenterFooter
PageSetup.CenterHeader = Sheet1.PageSetup.CenterHeader
Next Sheet

I guess the text for the header and footer could be stored as a variable or
cell reference if wanted.

Mark S.