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).