Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Header on Multiple Sheets without Changing Other Formatting
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Header on Multiple Sheets without Changing Other Formatting
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouped sheets page formatting will copy the header | Excel Worksheet Functions | |||
Changing dates on multiple sheets | New Users to Excel | |||
Using same Header & Footer for Multiple Sheets in Excel | Excel Discussion (Misc queries) | |||
Header or Footer to show up on multiple sheets in a document | Excel Worksheet Functions | |||
How do I change one cell across multiple sheets? | Excel Discussion (Misc queries) |