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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allow Users to Unfreeze Panes in a Protected Workbook/Sheet
Hi,
To freeze pane use this Sub freze() ActiveSheet.Unprotect , Password:="123" ' Type your password instead of 123 ActiveWindow.FreezePanes = True ActiveSheet.Protect , Password:="123" End Sub To unfreeze pane Sub unfreze() ActiveSheet.Unprotect , Password:="123" ' Type your password instead of 123 ActiveWindow.FreezePanes = false ActiveSheet.Protect , Password:="123" End Sub Regards Heera |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allow Users to Unfreeze Panes in a Protected Workbook/Sheet
On Feb 11, 4:51*pm, Heera wrote:
Hi, To freeze pane use this Sub freze() ActiveSheet.Unprotect , Password:="123" ' Type your password instead of 123 ActiveWindow.FreezePanes = True * ActiveSheet.Protect , Password:="123" End Sub To unfreeze pane Sub unfreze() ActiveSheet.Unprotect , Password:="123" ' Type your password instead of 123 ActiveWindow.FreezePanes = false ActiveSheet.Protect , Password:="123" End Sub Regards Heera I have a macro already in the workbook that unprotects and protects sheets. I left default frozen panes in some sheets, but I'd like to give the user the capability to unfreeze them if they want through the unfreeze icon from the view ribbon. Is that possible? |
Reply |
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 |