format rows to print at top for multiple tabs

[ESS Joan]

I regularly format large workbooks in Excel and would like to be able to
format all tabs with rows to repeat at the top of the page when printing.
When I highlight all tabs and go to page setup the rows to repeat at top
option is disabled. It would save a lot of time to be able to format the
entire workbook at once. How do I formatt many tabs within a workbook to
have a consistent area to print at the top of all sheets at once.

 

[Dave Peterson]

Maybe you could record a macro that changes this setting.

Then rerun it for each sheet--or even modify the macro to loop through all the
worksheets?

Option Explicit
Sub testme01()

Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
wks.PageSetup.PrintTitleRows = "$1:$2"
Next wks

End Sub


If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm