how to unprotect text box

[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.

 

[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

 

[SS]

Ok thanks got that sorted now.

Thank you.

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