Assign a macro to a command button

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 !
 
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??
 
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.
 
Back
Top