How do I unprotect a text box in an otherwise protected worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have many cells protected on a worksheet but also have a text box that I
want unprotected. I understand locking or unlocking individual cells but
can't find anything regarding locking or unlocking a text box. It appears
as if the sheet is protected, all text boxes are automatically protected.
 
Hi Gary,
When you protect the Workbook, (Go to Tools, Protection, Protect Sheet) The
protect sheet window will pop up, you should have some options to check or
uncheck under "protect worksheet for". Un-Check the objects box. This will
enable all locked cells to be protected, and text box's - being an object -
should not be locked.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unprotect Combo Box in a Protected Sheet 3
Unprotecting worksheets 2
Protecting Worksheet - Cannot move between cells. 2
Modifying a protect unprotect macro 10
Can't move between cells. (Not the scroll lock) 1
Inserting a comment box in a protected worksheet 2
Trying to unprotect Checkboxes 2
corrupted formula in protected worksheet 21

Back
Top