Changing the Protection prompt

  • Thread starter Thread starter Bob K
  • Start date Start date
B

Bob K

Is there a way that I can change the wording in the password
protection prompt, rather than the standard message that pops up when
protected cells are attempted to be changed on a protected worksheet?
 
Not that I have ever seen and this question is asked fairly frequently. You
can look at the enableselection property which if set to prevent it, will
not allow users to select locked cells. (in xl2002 and later, this can be
set under tools=>Protection=>Protect sheet. )
 

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

Back
Top