Using add-in in VBA with another module?
 

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!!


--
thinkingfield
------------------------------------------------------------------------
thinkingfield's Profile: http://www.excelforum.com/member.php...o&userid=16181
View this thread: http://www.excelforum.com/showthread...hreadid=276809

Using add-in in VBA with another module?
 

Is the other module outside of the Addin ?

--
Regards

Juan Pablo González

"thinkingfield" wrote in
message ...

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!!


--
thinkingfield
------------------------------------------------------------------------
thinkingfield's Profile:
http://www.excelforum.com/member.php...o&userid=16181
View this thread: http://www.excelforum.com/showthread...hreadid=276809