New to VBA development.
I developed an XLAM add-in for Excel 2007. This worked fine under development. It worked fine as an XLAM add-in. Making changes now there are problems.
The Function is not accessible as a macro. The add-in is activated but entering it in a cell fails to show it. The entered function shows #NAME?. Going to Developer-Macros fails to show it.
This is true in the XLSM worksheet as well. A Sub that calls the Function works fine.
The Function seems to work (called from a Sub) but it does not register as a macro in the original worksheet or XLAM add-in.
Any solutions or pointers? Thanks
Bookmarks