Sheet and workbook code: All sheets should have row 1 to 5 of Sheet1 to be repeated at top
Ignore this.
Misread the question.
Gord
On Thu, 25 Mar 2010 09:31:41 -0700, Gord Dibben <gorddibbATshawDOTca wrote:
Sub titles()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.WorkSheets
If ws.Type = xlWorksheet Then
ws.PageSetup.PrintTitleRows = "$1:$5"
End If
Next
End Sub
Gord Dibben MS Excel MVP
On Tue, 23 Mar 2010 18:51:49 -0700 (PDT), Subodh
wrote:
I want to make code to make all the sheets have same ROWS TO REPEAT AT
TOP on all the sheets of a workbook. ie. all the sheets in a work book
should have row1 to row5 of sheet1 to repeated at the top.
But, they cannot be made?
The Sheets to repeat on top is only for sheet
I want to make the sheet code for the workbook.
|