Enable an ActiveX macro button (Should be simple)

[Gard5096]

Hello,

I created a button in excel and programmed a simple macro into it. The problem is, I am not sure how to make it active on the excel worksheet.... whenever i click on the button, it just brings up the code in VBA. How do i activate/deactivate the button as needed? Is there a binary switch somewhere?


Thank you,

Nick

[Mumps1]

Hello Nick. If by "active" you mean 'run the macro', you first have to assign a macro to the button. Right click it, click 'Assign Macro' and then in the macro list that is displayed, click the macro you want the button to run. Click 'OK' and now the macro will run when you click the button.

[Gard5096]

That is an option for the Command Button, only for form controls.

[tigeravatar]

Gard5096,

You're probably stuck in Design View. Go to the Developer tab and click on "Design View" to toggle it on/off

[Gard5096]

Ahhhhh thats what I was looking for!! Thank you for your help