Using VBA macros from an Add-In

[deluxes]

I have created a large number of VBA macros and saved them as an
add-in. When I load the add-in in a sheet none of the macros show up
under the macro listing. I would like to be able to assign an add-in
macro to a button on my sheet or at least be able to run the macro.
Any help?

 

[JE McGimpsey]

I have created a large number of VBA macros and saved them as an
add-in. When I load the add-in in a sheet none of the macros show up
under the macro listing. I would like to be able to assign an add-in
macro to a button on my sheet or at least be able to run the macro.
Any help?

First, add-ins aren't loaded into a sheet, so I'm not sure what exactly
you're referring to.

In any case, while add-in macros don't show up in the macro list, they
are available via the list. When assigning the macro to the button, type
in the macro name. When you've typed in a valid name, the Edit button
will enable.

You can also set the button's macro programmatically, e.g.:

ActiveSheet.Buttons(1).OnAction = "MyAddIn.xla!MyMacro"


As in the Assign Macro dialog, you can also run any add-in macro via the
Tools/Macro/Macros... dialog. Just type in the name of the macro - when
you've typed in a valid name, the Run button will be enabled.

 

[deluxes]

Is there any way to get them to show up in the macros list so they can
merely be clicked on?

 

[deluxes]

I have it working now. I had "-" in my title of the add-in, removed it
and it works. Thanks for your help.