page setup in excel 2000

[dccunn]

In a workbook with multiple worksheets, I want to select all my worksheets and in the page setup, sheet tab, define the rows I want to print at the top of each page. Those options are grayed out unless I select each worksheet individually. Is there a fix for this problem?
Thank you.
Dave Cunningham

 

[Damon Ostrander]

Hi Dave,

Here is a workaround: simply use the following macro to set the number of title rows for all the selected sheets at once.

Sub MultiTitleRows()
Dim TitleRows As Range
Dim WS As Worksheet
Set TitleRows = Application.InputBox( _
"Enter title rows to be used for each selected worksheet", _
"Multi-sheet Page Setup", Type:=8)
For Each WS In ActiveWindow.SelectedSheets
WS.PageSetup.PrintTitleRows = TitleRows.Address
Next WS
End Sub