OMG Excel you are driving me nuts today.

I want to create a simple set of macros that I can pass around as an AddIn. When I run it as a Macro in my workbook it’s fine. It doesn’t work as an AddIn.

The AddIn creates a menu item under the AddIns worksheet menu. When I try to call the function from the menu item, I see this error.

“Cannot run the macro FOO. The macro may not be available in this workbook or all macros may be disabled.”

All macros are enabled but I can’t figure out how to make the functions from the AddIn show up in either the Macros list or in the AddIn menu I created.

More to come…

Update March 26, 2013, 1:17 PM

I’m making progress. It looks like there might be a name space collision between the AddIns default workbook “ThisWorkbook” and the active documents workbook name “ThisWorkbook.”

I renamed the AddIn Workbook and references that when I called the AddIn function from the AddIn menu and I was able to call the method (AddInName.FOO).

Joe Cotellese @JoeCotellese