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.