Print heading on everypage

[jamex]

How to print heading on everypage for all sheets of a workbook.
I grouped all sheets, then went as File->pagesetup->sheet tab, but i
see print titles option is disabled, why. But for single sheet it is
working. Please suggest how to enable it for *all sheets*.
THANKS

 

[Dave Peterson]

I don't think you can. You'll have to go through each sheet.

 

[Jim May]

Excuse the work wrapping, but this should help (adjust to your needs).

Customize the Page Sections (Header/Footer)of a worksheet as desired.
Then from this
same worksheet - run this macro:

Sub change_all_headers()
With ActiveSheet
LF = .PageSetup.LeftFooter
CF = .PageSetup.CenterFooter
RF = .PageSetup.RightFooter
LH = .PageSetup.LeftHeader
CH = .PageSetup.CenterHeader
RH = .PageSetup.RightHeader
End With

For Each sht In Sheets
sht.Select
ActiveSheet.PageSetup.LeftFooter = LF
ActiveSheet.PageSetup.CenterFooter = CF
ActiveSheet.PageSetup.RightFooter = RF
ActiveSheet.PageSetup.LeftHeader = LH
ActiveSheet.PageSetup.CenterHeader = CH
ActiveSheet.PageSetup.RightHeader = RH
Next sht
End Sub

Report back, if problems.
Remember to back up you r file before trying ANYTHING NEW!!

 

[tonywig]

I had the same problem and this sorted it - thanks Jim.