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.