Typing in a text box on a protected worksheet

[dpaton05]

My spreadsheet needs to be locked but I have a text box on it that the user needs to type in. How do I unlock it so I can type in it?

 

[Yongle]

When protecting the sheet, scroll through the options to the second page and check "Edit Objects"

But it is "all or nothing" - if you have other objects requiring protection then replace the existing textbox with an Active-X textbox (can be edited when sheet protected)
Developer Tab \ Insert \ Active-X TextBox \ Click on where to go in worksheet and drag to size required
If you cannot see Developer tab Right-Click on bottom half of menu ribbon \ Customize The Ribbon \ check Developer box in window on right