Creating a Custom Dialog Box

[Mike555]

In Microsoft Excel, when a user attempts to change a protected cell a dialog box appears with the following statement:

The cell or chart you are trying to change is protected and therefore read-only.

To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Tools menu, Protection submenu). You may be prompted for a password.

Is it possible to change this message using VBA? I need the dialog box to say "Contact the System Administrator for the password."

Thanks!

 

[xlbo]

Hmmm - don't think this is possible without some heavy API calls (have a look at

http://www.allapi.net

if you are interested)
Other then that, not even "application.displayalerts = false" stops the error message appearing and there would be no way to trap the event anyway 'cos the workshet CHANGE event doesn't fire until after the error message, by which time, there is no change and therefore the event doesn't fire at all

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde