Using add-in in VBA with another module?

[thinkingfield]

I created an add-in that works fine when I use a function from the
add-in in an excel spreadsheet. I can even use the menu item "insert
function" to add any of the functions from my add-in. The problem
arrises when I try to use any of the functions in VBA. I get an error
that any of the functions do not exist. The add-in appears in another
module but I have used "Public" for all the functions so I should be
able to access them.

So to recap, the add-in functions work fine in a spreadsheet but not in
VBA. The functions appear in their own module and are all "public".

Any help please!!! Thanks!!

 

[Juan Pablo González]

Is the other module outside of the Addin ?