View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Changing the Protection prompt

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

--
Regards,
Tom Ogilvy


"Bob K" wrote in message
m...
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?