How Do I Change The Message In Excel Password Protection?
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?
"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?
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.
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.
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!
Good luck!
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.
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.