Hi, I wrote an addin that has several public functions. When I creat
another workbook I can call the functions perfecly within
spreadsheet. However, when I try to call the functions using VBA I ge
a 'function not defined'.

There should be a way to call a function using VBA from an addin jus
like calling any other excel function, is there special syntax fo
calling an addin function? Or, do I have to do something else to m
addin besides making the functions public?

BTW, I see the module in the project explorer. When I look into th
objects window I can see the functions when I highlight the addi
module, but NOT when I highlight the new workbook module.

Thanks

--
thinkingfiel
-----------------------------------------------------------------------
thinkingfield's Profile: http://www.excelforum.com/member.php...fo&userid=1618
View this thread: http://www.excelforum.com/showthread.php?threadid=27721