Hi

I have a workbooks where I use the function freeze panes. This works fine
someti es, however sometime when another user opens the workbook it loses the
freeze pane which is causing a lot of problems. The workbook is shared and
certain cells are protected.

Any help would be appreciated to why this is happening.

Thanks

try toolsprotectionprotect workbookwindows
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"JS82" wrote:

Hi

I have a workbooks where I use the function freeze panes. This works fine
someti es, however sometime when another user opens the workbook it loses the
freeze pane which is causing a lot of problems. The workbook is shared and
certain cells are protected.

Any help would be appreciated to why this is happening.

Thanks

Thanks John, that seems to of worked!

Thanks again

"John" wrote:

try toolsprotectionprotect workbookwindows
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"JS82" wrote:

Hi

I have a workbooks where I use the function freeze panes. This works fine
someti es, however sometime when another user opens the workbook it loses the
freeze pane which is causing a lot of problems. The workbook is shared and
certain cells are protected.

Any help would be appreciated to why this is happening.

Thanks