Print same column headings on each page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Page Setup, Sheet tab, under Print titles, both the "Rows to repeat at top" and "Columns to repeat at left" boxes are greyed out and unavailable. Any clues?
 
If you access Page Setup from the Print Preview, those commands aren't available. Close the Print Prieview and go in to the Setup option from the file menu

tj
 
-----Original Message-----
In Page Setup, Sheet tab, under Print titles, both
Click to expand...
the "Rows to repeat at top" and "Columns to repeat at
left" boxes are greyed out and unavailable. Any clues?
.
Click to expand...
Vino

I don't know why they are unavailable but you can use this
code


Sub ReptRows()
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
.PrintTitleColumns = "$A:$A"
End With
End Sub

Change to suit. Change name to Sub Before_Print() and copy
it into your Personal Workbook so that it is available for
every workbook if necessary.

Regards
Peter
 
Peter Atherton said:
....
I don't know why they are unavailable but you can use this
code
Click to expand...
....

Code not needed. If the OP started off in Print Preview, then clicked on the
Setup... button, the whole Print Title section of the Sheet tab in the Page
Setup dialog will be greyed out. To set them, it's necessary to use File >
Page Setup... from the menu.
 
Back
Top