Custom error message - VBA

[Margiemarsupial]

Hi

So, I have a spreadsheet with two layers of VBA approval buttons built into the form. Meaning, round one of approvals protects the sheet using one password and round two protects it using a different password. This way, you can’t remove a signature after round one is complete.
As you’d hope in this case, an error occurs when you try to click a button associated with round 1. Since the passwords are different, the debug error pops up.
So my question is - can I change that to be a custom error message? Instead of “end/debug” standard, I want to to pop up and say something like “Signature can no longer be overwritten. Please contact your xxx rep for more details.”

 

[diddi]

hi and welcome to MrExcel. if you are getting debug issues, there is a problem with your code. can you post the code

 

[sxhall]

Can you use an 'If' for when the button is clicked and control the outocme? If the passwords do not match, show messsage box if they match then run the code.

As above the code would be useful.

 

[Margiemarsupial]

The debug is occurring because the two passwords associated with the approval buttons do not match. That is exactly what I want because I want those other signatures to be locked in place after round one.
I was hoping I could customize the error message rather than it looking like my code isn’t work when it is.

 

[diddi]

you dont write code that fails on errors. you are supposed to capture the error or stop it occurring. cant assist without seeing what you have written