How to assign a macro to a button in Excel 2003?

[Guest]

In prior versions of Excel, once you added a button to a page a window would
automatically pop up and have option to "assign macro". Some genius at
Microsoft decided this was too simple. Anyone know if this option is still
there or do you have to copy the code and paste it in VB Editor?

 

[Tom Ogilvy]

It still does that for buttons from the forms toolbar. I suspect you are
adding a commandbutton from the control toolbox toolbar. You don't assign
macros to these because they use events. If you want the old style
behavior, use a button from the forms toolbar.

 

[Guest]

Thanks, you are correct... my mistake.

It still does that for buttons from the forms toolbar. I suspect you are
adding a commandbutton from the control toolbox toolbar. You don't assign
macros to these because they use events. If you want the old style
behavior, use a button from the forms toolbar.