![]() |
Freeze Pane problem
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 |
Freeze Pane problem
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 |
Freeze Pane problem
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 |
All times are GMT +1. The time now is 10:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com