how to unprotect text box

S

SS

I have managed to protect the cells I require in my worksheet, but I cannot
workout
how to unprotect a text box so that I can have work typed in it.
That is an inserted text box as opposed to a cell.

help please.
 
G

Gord Dibben

Right-click on the edge of the textbox and "format text box"

Go to Protection tab and uncheck the two locked options.

Protect the sheet.


Gord Dibben MS Excel MVP
 
S

SS

Ok thanks got that sorted now.

Thank you.

Gord Dibben said:
Right-click on the edge of the textbox and "format text box"

Go to Protection tab and uncheck the two locked options.

Protect the sheet.


Gord Dibben MS Excel MVP
Click to expand...
 
Top