Assign a Macro to a Button

[gheyman]

I have buttons on tabs (created from the toolbox) that I want to assign Macros to. I can click the button go to "Assign Macro" and assign the macro I want. But when I go back to the Button it doesnt have a macro assigned to it. This is happening on several tabs on several buttons (all of them). I saved, opened closed excel, the same thing keeps occuring. I even created new buttons and it happens to them as well.

Why is this happening?

Thanks
Greg

 

[cjcobra]

You usually have to right-click to assign the macro. After you assign it, will the button work right afterwards? Try running the macro without the button to make sure that's not it.

 

[shg]

For buttons from the Control Toolbox, right-click the button and select View Code. That's because they have a Click event with a defined signature that is processed by the sheet module.

That said, I'm inclined to use buttons from the Forms Toolbar or autoshapes rather than ActiveX buttons; they have fewer bad behaviors. In that case, you do indeed right-click and select Assign Macro.

 

[gheyman]

Right clicking did the trick.

To answer the other question, yes I did run the code so I know it wasnt anything in the code doing it.

Once I did a right click on buttons, it let me assign the macros and they stuck!

THANKS!