setting a header and footer for entire worksheet

[basher450]

hi

ok, setting an header and footer for a sheet is easy.
is there a way to set an header and footer for the entire worksheet, or save a custom header and footer so I can use on other sheets.

I have 9 sheets I want to add headers and footers and I don't what to go one by one.

thank you

 

[Oaktree]

Just select all of the sheets (hold down shift and click on each sheet tab) to which you'd like to apply your header before you create it.

 

[Norie]

Or you could use code in the workbook BeforePrint event.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
    With ActiveSheet.PageSetup
        .LeftHeader = ""
        .CenterHeader = "MyHeader"
        .RightHeader = "&P"
    End With
End Sub

 

[viper]

you can also just right click on any sheet tab and then choose select all sheets then go to page setup and setup your header and footer.

 

[basher450]

thank you all

 

[basher450]

thank you all