Trouble calling Add-In Macros
If the add-in name has embedded spaces use
Application.Run "'My Addin.xla'!MyMacro"
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Norman Jones" wrote in message
...
Hi Scott,
Try:
Public Sub Tester()
Application.Run ("MyAddin.xla!MyMacro")
End Sub
Replace the addin and macro names to accord with your values.
---
Regards,
Norman
wrote in message
oups.com...
I created an Excel Add-in with some macros in a module. I went to
Tools Add-Ins and selected the Add-In so it loads everytime I open
Excel. When I try to call one of the Add-In macros from a macro in my
main excel file, it doesn't work. My main excel macros can't see the
Add-In's macros. How do I get them to see the Add-In's macros.
--Scott
|