Assign a macro to a command button
 

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 !

Assign a macro to a command button
 

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

"SheriTingle" wrote:

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 !

Assign a macro to a command button
 

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??

"Barb Reinhardt" wrote:

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

"SheriTingle" wrote:

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 !

Assign a macro to a command button
 

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
--
Brevity is the soul of wit.


"SheriTingle" wrote:

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??

"Barb Reinhardt" wrote:

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

"SheriTingle" wrote:

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 !

Assign a macro to a command button
 

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.

SheriTingle wrote:

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??

"Barb Reinhardt" wrote:

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

"SheriTingle" wrote:

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 !

--

Dave Peterson