Microsoft Excel relies on the Visual Basic language for some of its advanced features, including the use of macros. When a Visual Basic macro generates an error in Excel, it presents the user with an option to "Debug" the underlying code. If selected, this option opens the macro code in a Visual Basic editing window. You may find this undesirable, especially in situations where the current user is not the macro's creator. Disabling the Debug option and thus protecting the underlying code is possible.
- Skill level:
- Moderately Easy
Other People Are Reading
Click "Tools," "Macro" and then "Visual Basic Editor."
In the Visual Basic editor window, click "Tools," then "VBAProject Properties."
Click the "Protection" tab.
Click to place a check next to "Lock project for viewing." Enter a password in the "Password" field, then type the password again in the "Confirm Password" field.
Save the workbook, then close and reopen it for the changes to take effect.
Tips and warnings
- While this method protects the code in the case of an unexpected error, it is considered good programming practice to write code specifically to handle errors.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for