Assign a macro to a command button

[Guest]

Hi and thanks for the help. I am using Excel 2003.

I accidently used the wrong button and am hoping there is a fix. I need to
run a macro from a button.

I know that if I use the button (control button) from the forms toolbar the
first thing it asks me to do is to assign a macro and all would work fine.
But...

I used the command button from the control toolbox to make the buttons (I
made many of them and would prefer not to remake them). I would like to run a
macro from each of these buttons and now I can't figure out how to attach the
macro to the buttons I've already made. The buttons came from the command
button on the control toolbox.

Is there a way to attach a macro to these buttons?? THANKS !

 

[Guest]

You need to right click on the button and select ASSIGN MACRO.

 

[Guest]

That's what I thought too but it doesn't work that way with the button I
used. It does not allow assign macro with a right click when using the
command button from the control toolbox to make the buttons. So is there
another option??

 

[Guest]

Hi, take a look at this: http://www.mrexcel.com/tip068.shtml

Make note of where you have to click on the button in order to assign the
macro.

Dave

 

[Dave Peterson]

If you use the button from the Forms toolbar, you'll see that option.

If you use the commandbutton from the Control Toolbox toolbar, you won't.

I'd delete the original button and replace it with one from the Forms toolbar.