I get a message saying the addin is file losing it’s VB Project when I open Excel or load an Addin.
The message reads, “This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.“
This happens when VBA for applications is not installed with Office. It is installed by default in most cases. To resolve the situation, reinstall Office or Excel and install the Visual Basic for Application components.
Excel 2011 on the Mac is known to not install VBA by default.