Repeating Header
 

Is there a way to have a spreadsheet automatically repeat the header every 25
rows without using the Freeze Frame?

Reason: the users of some huge spreadsheets need the header repeated for
expediency in looking things up and troubleshooting entries.

Repeating Header
 

Not without adding it.

Freeze Panes always works well for me. what's the problem?

--
Regards,
Tom Ogilvy

"john d" wrote:

Is there a way to have a spreadsheet automatically repeat the header every 25
rows without using the Freeze Frame?

Reason: the users of some huge spreadsheets need the header repeated for
expediency in looking things up and troubleshooting entries.

Repeating Header
 

John,

I dont know of a way except when printing you can select a row to
repeat at top.....for just when viewing the spreadsheet I only know of
freeze panes that would do this for you.

Why can you not use frozen panes?

Duncan


john d wrote:

Is there a way to have a spreadsheet automatically repeat the header every 25
rows without using the Freeze Frame?

Reason: the users of some huge spreadsheets need the header repeated for
expediency in looking things up and troubleshooting entries.

Repeating Header
 

Is there a way to automate the Freeze Frame function so it loads when the
speadsheet opens?

"Tom Ogilvy" wrote:

Not without adding it.

Freeze Panes always works well for me. what's the problem?

--
Regards,
Tom Ogilvy

"john d" wrote:

Is there a way to have a spreadsheet automatically repeat the header every 25
rows without using the Freeze Frame?

Reason: the users of some huge spreadsheets need the header repeated for
expediency in looking things up and troubleshooting entries.

Repeating Header
 

Private Sub Workbook_Open()
With ThisWorkbook
.Worksheets(1).Activate
.Worksheets(1).Range("A1").Select
.Worksheets(1).Rows(2).Select
ActiveWindow.FreezePanes = True
End With
End Sub

put this in the Thisworkbook module of your workbook.

Change it to reflect your actual situation.

--
Regards,
Tom Ogilvy

"jduran" wrote:

Is there a way to automate the Freeze Frame function so it loads when the
speadsheet opens?

"Tom Ogilvy" wrote:

Not without adding it.

Freeze Panes always works well for me. what's the problem?

--
Regards,
Tom Ogilvy

"john d" wrote:

Is there a way to have a spreadsheet automatically repeat the header every 25
rows without using the Freeze Frame?

Reason: the users of some huge spreadsheets need the header repeated for
expediency in looking things up and troubleshooting entries.

Repeating Header
 

Private Sub Workbook_Open()
Range("A2").Select
ActiveWindow.FreezePanes = True
End Sub


That should do it, test though as i dont know how big your header is


Duncan


jduran wrote:

Is there a way to automate the Freeze Frame function so it loads when the
speadsheet opens?

"Tom Ogilvy" wrote:

Not without adding it.

Freeze Panes always works well for me. what's the problem?

--
Regards,
Tom Ogilvy

"john d" wrote:

Is there a way to have a spreadsheet automatically repeat the header every 25
rows without using the Freeze Frame?

Reason: the users of some huge spreadsheets need the header repeated for
expediency in looking things up and troubleshooting entries.