Prev: how can I change MMDDYY to YYYYMMDD?
Next: Spreadsheet filename no longer appears in title bar
From: David on 21 Apr 2010 16:20
Hello

I have a file with sheets that have the same header. Each tab has specific
page setup formatting that I need to keep intact. I tried highlighting all
tabs and changing the header via page setup but the other page setup
formatting changed to the formatting of the first sheet.

Is there a way to add the header I would like to put on all tabs to the
header drop down menu on header/footer tab in page setup.

Thanks
From: Gord Dibben on 21 Apr 2010 19:51
Only through VBA.

Sub Text_In_AllFooters()
Dim WS As Worksheet
For Each WS In ActiveWorkbook.Sheets
WS.PageSetup.CenterHeader = "Some text or whatever"
Next
End Sub

More details on what you want in the header could get you less generic code
tailored to your needs.


Gord Dibben MS Excel MVP

On Wed, 21 Apr 2010 13:20:01 -0700, David <David(a)discussions.microsoft.com>
wrote:

>Hello
>
>I have a file with sheets that have the same header. Each tab has specific
>page setup formatting that I need to keep intact. I tried highlighting all
>tabs and changing the header via page setup but the other page setup
>formatting changed to the formatting of the first sheet.
>
>Is there a way to add the header I would like to put on all tabs to the
>header drop down menu on header/footer tab in page setup.
>
>Thanks

 | 
Pages: 1
Prev: how can I change MMDDYY to YYYYMMDD?
Next: Spreadsheet filename no longer appears in title bar