Home » questions » How do I change the message in Excel password protection?

How do I change the message in Excel password protection?

2
2006-08-02 03:01:35, Category: Programming & Design
You know, you protect a worksheet and when another person tries to change a cell, a window pops up saying.. "The Cell you are trying to change is password protected....." Can I change that message to something more personal, like" "You are trying to do something you're not authorized for.... "Contact Systems Admin...." If so, how can it be done?

Answers

  1. SquirrelNutz

    On 2006-08-02 06:43:17


    Unfortunately you cannot change this application-generated dialog. There's simply no way to intercept the event that causes this dialog to open - and therefore no way to modify it. Good luck!

  2. I have arrived at Level 5

    On 2006-08-02 13:47:33


    If you make it where a person is unable to "select locked cells" when you protect the spreadsheet, then they cannot even click in the cell to edit it. This avoids even needing the error message to be changed. Oh yeah, I forgot. I have used Data Validation to approximate the same thing. If you limit the cell to allow "text length" of 0 to 0 and change the Error Alert to "Stop," then you have control over an error message.