Excel 2007 freeze pane problem
Microsoft Excel, Excel 2007, Excel 2003
Dear Sir,Is there any method in Excel 2007 to enabling freeze pane option in protected Sheet of Excel 2003.
Regards
Furqan Ahmed
Question
Microsoft Excel, Excel 2007, Excel 2003
Dear Sir,Is there any method in Excel 2007 to enabling freeze pane option in protected Sheet of Excel 2003.
Regards
Furqan Ahmed
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
According to this microsoft article, freeze pane is not available when in cell editing mode or when a worksheet is protected.
Browse more Questions and Answers on Microsoft Windows.
Looking for relevant Microsoft Windows Whitepapers? Visit the SearchEnterpriseDesktop.com Research Library.
Discuss This Answer
You must be logged-in to discuss a question. Log-in/Register
Not an answer so just putting in discussion.
I can create a workbook with a sheet protected and then freeze pane it.
I can also create a protected sheet with freeze pane on it but then people can unfreeze their copy.
So I guess the answer is yes, just do what you would normally do.
I guess this means I don’t under stand your question because the way I understand it you just do the normal freeze pane.
