If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel-Footer Mass change of only Header and not footer
In Excel, there are 20 worksheets with independent header
and footers defined. Now I need to change only header en-mass and without changing the footer. When I try to change the header by selecting multiple worksheets and change the header, the footer of the main page gets applicable to all sheets. Can we change only header at one-go and not the footer. |
#2
|
|||
|
|||
Excel-Footer Mass change of only Header and not footer
You could change the headers programmatically:
'================================== Sub ChangeHeader() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets With ws.PageSetup .LeftHeader = "&D" .CenterHeader = "" .RightHeader = "&F" End With Next ws End Sub '==================================== M.Raguram wrote: In Excel, there are 20 worksheets with independent header and footers defined. Now I need to change only header en-mass and without changing the footer. When I try to change the header by selecting multiple worksheets and change the header, the footer of the main page gets applicable to all sheets. Can we change only header at one-go and not the footer. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|