Unprotect a textbox in a protected worksheet

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

Guest

Is there a way to add an unprotected textbox to a protected document? I have
a worksheet in which I wish to protect several cells. But, on the same
worksheet, I have several textboxes I have entered in unprotected cells that
I'd like to remain unprotected so that other users can enter text. But, when
I reprotect the document after adding the textboxes, the textboxes are
non-functional (i.e. they can not be clicked in to enter text). There is no
error message (that the textbox is read-only) like that seen when clicking in
a protected cell. The textboxes just can not be entered.
 
You must log in or register to reply here.

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

Protect and Unprotect all worksheets with macro 2
Excel Protection 2
Protection on Worksheets 5
unprotect worksheet when...... 1
Unprotect sheet to "Refresh All" Access queries 2
Qualifying permissions in protect unprotect macro. 3
Inserting a comment box in a protected worksheet 2
Unable to unprotect an Excel Worksheet 2

Back
Top