Excel 2007 freeze pane problem

90 pts.
Tags:
Excel 2003
Excel 2007
Microsoft Excel
Dear Sir, Is there any method in Excel 2007 to enabling freeze pane option in protected Sheet of Excel 2003. Regards Furqan Ahmed
ASKED: May 24, 2008  5:35 AM
UPDATED: October 27, 2010  3:46 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

According to <a href=”http://office.microsoft.com/en-us/excel/HP012170481033.aspx”>this</a> microsoft article, freeze pane is not available when in cell editing mode or when a worksheet is protected.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ysrd
    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.
    430 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following