Hank, the Spreadsheet Assistant, http://www.add-ins.com/assistnt.htm, has a
feature in it that will set the freeze pane and zoom on all selected sheets.
The only restriction is that the to top left cell and the freeze pane cell
must be visible so that freeze panes can be set.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Hank" wrote in message
...
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