Override Alert Message Text

    Is there a way to override the text that excel shows in its alert messages?


    Right now I have a protected worksheet, and so when a user tries to change a cell an alert message shows up giving instructions on how to unprotect the sheet (Tools menu, protection submenu). I'd like to either put a different message in there, or else prevent this popup from appearing altogether (but not prevent all popups).

    Re: Override Alert Message Text


    As far as I know there is no way to override that message. You can either password protect the sheet to keep users from unprotecting it, or you might turn off protection altogether and use a macro such as this in the worksheet code module:


    Code
    Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    Application.Undo
    Application.EnableEvents = True
End Sub

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login