WindowFreeze Panes should save with the workbook.

Note: without VBA you can't "Freeze Panes" on every sheet at once.

Must be done individually as it is a Window-only setting.


Gord Dibben MS Excel MVP

On Thu, 28 Jun 2007 20:55:03 -0500, "Hank" wrote:

In Excel 2003 I would like to Freeze the header row on each worksheet and
have this "Freeze Pane" save when the workbook is closed.

Should the Freeze pane save? If not, is there a way to do this so the
header rows are always visible. I can indicate which rows I want to print
at the top of each page with page setup. I'm trying to keep from haveing to
freeze pane each time I open the workbook.

Thanks
Hank