A
ac1179
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!
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!