how to unprotect text box

  • Thread starter Thread starter SS
  • Start date Start date
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.
 
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
 
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...
 

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

protecting a text box in spreadshhet 2
Excel Protection 2
Move to next unprotected cell 6
Editing an unprotected Cell in a Protected Worksheet in Excel 2003 1
Protecting worksheet 11
Word Macro to insert text and save as PDF 4
Unprotect Sheet for the duration of a script 7
Macro to unprotect with password 1

Back
Top