software

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 quot;protect worksheet forquot;. 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.

quot;garyfquot; wrote:

gt; I have many cells protected on a worksheet but also have a text box that I
gt; want unprotected. I understand locking or unlocking individual cells but
gt; can't find anything regarding locking or unlocking a text box. It appears
gt; as if the sheet is protected, all text boxes are automatically protected.