Check that the word "Shared" appears in the Excel title bar at the top. Open the Visual Basic Editor and try and open the VBProject. You should see a message saying "Project is Unviewable". Resave the Workbook as an Add-in - Not Working ...
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...