Using Excel Add-in functions

  • Thread starter Thread starter David Evans
  • Start date Start date
D

David Evans

I'm having trouble accessing public functions and subs in
and Excel Add-in. I have added the .xla file via the Add-
ins menu option. The Auto_Open and Auto_Close subroutines
activate when I open and close Excel. How do I use the
functions in VBA in my .xls file?

Thanks,
David
 
How do I use the
functions in VBA in my .xls file?
Click to expand...

You probably have to refer to the name of the addin in VB when you call the
function, for instance instead of

Initialize()

you call

AddinName.Initialize()
 
Back
Top