You should see a message saying "Project is Unviewable". Resave the Workbook as an Add-in - Not Working Save the Excel (.xlsm) workbook as an Excel Add-in (.xlam). Close this Excel workbook without saving the changes. Test out your newly saved add-in (open it, access the vbe, try...
Unviewable VBA project and VBA source code The “Unviewable VBA project” option locks access to the VBA macros, makes the VBA project unviewable, and disables VBA debug mode. After applying this option, the VBA project and macros will be unviewable and unavailable in the protected workbook. Any...
If this password is lost, you will not be able to modify the workbook structure, such as adding new sheets. What Is VBA Project Password This is the password you set in the VBA Project Properties window. If this password is lost, the VBA project is locked and unviewable. ...