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:

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

Participate now!

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