Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allow Users to Unfreeze Panes in a Protected Workbook/Sheet
my company upgraded from excel 2003 to 2007. I have a workbook with
worksheets that's password protected. In excel 2003 users could unfreeze panes from the menu options without unprotecting the sheets. But in excel 2007 the freeze/unfreeze panies icon is grayed out. Is there some macro code that i could include to let users unfreeze panes? When you manually protect a sheet... under the dialog box "Allow all users in this worksheet to" there's a list of options... such as: select locked cells, unlock cells, delete rows, etc. But I don't see freeze panes. Please help. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I allow users to fill down on a protected sheet? | Excel Discussion (Misc queries) | |||
Code to prevent Remove Split or Unfreeze Panes? | Excel Discussion (Misc queries) | |||
Disable Unfreeze Panes and Remove Split, how? | Excel Discussion (Misc queries) | |||
There is no freeze/unfreeze panes option in the windows menu | Excel Worksheet Functions | |||
Freeze/Unfreeze Panes and window display | Excel Programming |