Margiemarsupial
New Member
- Joined
- Jun 1, 2021
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
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.”
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.”