WindowFreeze Panes works only on the active window so you cannot group the
sheets and do the job.
You could loop through the sheets with a macro to set each sheet.
As far as the "unfreezing" after saving as a workspace goes.........saving as a
workspace does not preserve the Window settings.
See this google post for more info and a workaround and KB article or macro by
Gary Brown to set each workbook Window setting as they open.
http://snipurl.com/1mvu7
Gord Dibben MS Excel MVP
On Thu, 31 May 2007 13:29:00 -0700, zoom zoom
wrote:
I have a workbook with 14 worksheets in it and they all have the rows frozen
to display the columns. When I save several of these workbooks to a
workspace, close, and then re-open the workbooks, all of the rows are
unfrozen. Two questions: How do I keep all rows frozen in all worksheets?
and, How do I freeze all worksheets within each workbook without going page
by page? (All worksheets are identically set-up and represent months of the
year for data input).
Thanks to whoever can help with this possible bug.