Using add-in in VBA with another module?

[thinkingfield]

Yes.

There is only one module within the addin. I created anothe
spreadsheet and tried to access the addin's module from the ne
spreadsheet's module.

 

[keepITcool]

make sure the addins "project name" is unique (not VBAproject)
then add a reference to it in your "calling" project.

then activate the "calling" workbook
then open object browser, select the references "addin project"
in the ObjBrowsers dropdown to ensure the functions
are really exposed by the addin. (and not blocked by a line called..
Option Private module?



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam

thinkingfield wrote in message

Yes.

There is only one module within the addin. I created another
spreadsheet and tried to access the addin's module from the new
spreadsheet's module.