Can you cann a VBA function in a workbook from an addin

[Kalen Brunham]

Is there anyway to call a function in a workbook's VBA project from an
addin?


What I am trying to do is write an addin the computes data based on the
worksheet data but then returns a pointer to the instance of the returndata
object so that it can be reused by additional functions.

I would like to have the addin functions driven by their toolbar click
event, but I am unsure how to make the client event call a specific method
within the activeworkbook's instance of the returndata object. What I was
hoping to do is have the event click call a workbook function, that would
then call the method from the returndata instance.

 

[Howard Kaikow]

Take a look at the Help for Excel's Run method.