The Lock VBA Project option provides a simple way to prevent end-users from accessing your VBA project. This feature marks the VBA project as locked, making it impossible to view, access, or modify. It does not use password protection.
If the end user tries to access a locked VBA project, the following error message is displayed (Project Locked – Project is unviewable):
Remove Existing VBA Passwords
If you use this option, we recommend removing any existing password from your VBA project. A password becomes redundant when the project is locked. Furthermore, using a long password with this option can cause crashes in Excel 2007.
If you prefer to keep a password, consider using the Prevent access to VBA editor option instead.
Note that macros remain functional.
This option is compatible with our VBA compiler, which offers a higher level of security for your VBA code.
