How to call a macro in an add-in module?

[JenniferMurphy]

RoryA solved my problem getting a worksheet function to call an add-in macro in this thread: 1186404.

Now I'd like to be able to call a macro in my add-in module from a control button in a sheet. But when I right-click the shape and select Assign Macro, none of the add-in macros show up even though I can run add-in functions from that worksheet. And the only options in the "Macros In:" dropdown are open workbooks.

I would like to run the AverageRatings macro in the TestSubs folder of "Jen Add-ins.xlam" from a control button.

Thanks

 

[Domenic]

Actually, even though the procedures in your add-in are not listed in the Macro dialog box, you can simply type the procedure name in the Macro Name field, and then click on OK.

 

[JenniferMurphy]

Actually, even though the procedures in your add-in are not listed in the Macro dialog box, you can simply type the procedure name in the Macro Name field, and then click on OK.

That worked, thanks.

 

[Domenic]

You're very welcome, glad I could help.

Cheers!