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

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?

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.

--
Regards,
Tom Ogilvy

"Mike" <Mike@discussions.microsoft.com> wrote in message
news:AEAAE378-B029-4709-A9CA-B3F0E44C4BB9@microsoft.com...
> 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?

Thanks, you are correct... my mistake.

"Tom Ogilvy" wrote:

> 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.
>
> --
> Regards,
> Tom Ogilvy
>
> "Mike" <Mike@discussions.microsoft.com> wrote in message
> news:AEAAE378-B029-4709-A9CA-B3F0E44C4BB9@microsoft.com...
> > 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?
>
>
>