Trouble calling Add-In Macros
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 |
Trouble calling Add-In Macros
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 |
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 |
All times are GMT +1. The time now is 06:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com