| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the Protection prompt
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| protection and changing formulas | Excel Discussion (Misc queries) | |||
| Want a yes/no prompt before changing data in cell | Excel Discussion (Misc queries) | |||
| Prompt for protection password when not trying to access VBA | Excel Discussion (Misc queries) | |||
| Changing Colours With Protection | Excel Discussion (Misc queries) | |||
| Changing password protection on sheets | Excel Discussion (Misc queries) | |||
![Bob K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
