Active x control click issue

[drluke]

I want to assign a macro to an active x command button. However the code is not in the sheet object, but rather in a module.
What do I have to do for the code to run from the module? At the moment when the button is clicked, nothing happens.
The reason I don't have the code in the worksheet object, is because I want to make this macro as an Add-In. Any advice would
be appreciated.

 

[Fluff]

You will need to replace your ActiveX controls with form controls.

 

[drluke]

Ah right - Thank you!

 

[Fluff]

You're welcome