How do I Assign Macro to a button?

[BellExcel]

I have a problem in trying to assign a macro to a button in Excel 2002. When
I create the button, and then click on the button, the "Assign Macro" command
is grayed out (unavailable). I cannot figure out what's wrong.

[Debra Dalgleish]

When you click on the button, click on its border. Around the button,
you'll see a thick dotted border.
(If you click inside the button, you'll see a thick border with diagonal
lines, and you won't be able to assign a macro.)

Right-click on the button border, and choose Assign Macro.


BellExcel wrote:
> I have a problem in trying to assign a macro to a button in Excel 2002. When
> I create the button, and then click on the button, the "Assign Macro" command
> is grayed out (unavailable). I cannot figure out what's wrong.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[BellExcel]

For some reason, this does not seem to work for me. Should I be in the
control box design mode? I would think so, but the assign macor option does
not appear. Should I choose "Command Button Object" and then "Edit".

"Debra Dalgleish" wrote:

> When you click on the button, click on its border. Around the button,
> you'll see a thick dotted border.
> (If you click inside the button, you'll see a thick border with diagonal
> lines, and you won't be able to assign a macro.)
>
> Right-click on the button border, and choose Assign Macro.
>
>
> BellExcel wrote:
> > I have a problem in trying to assign a macro to a button in Excel 2002. When
> > I create the button, and then click on the button, the "Assign Macro" command
> > is grayed out (unavailable). I cannot figure out what's wrong.
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

[Debra Dalgleish]

The Assign Macro command will only appear if the button is from the
Forms toolbar.

If you used a button from the Control toolbox, you shouldn't see Assign
Macro in the shortcut menu. To run a macro when a button from the
Control toolbox is clicked:

In Design mode, double-click the button
Where the cursor is flashing, type the name of the macro you want to
run. For example:

Private Sub CommandButton1_Click()
MyMacro
End Sub


Close the Visual Basic Editor.



BellExcel wrote:
> For some reason, this does not seem to work for me. Should I be in the
> control box design mode? I would think so, but the assign macor option does
> not appear. Should I choose "Command Button Object" and then "Edit".
>
> "Debra Dalgleish" wrote:
>
>
>>When you click on the button, click on its border. Around the button,
>>you'll see a thick dotted border.
>>(If you click inside the button, you'll see a thick border with diagonal
>>lines, and you won't be able to assign a macro.)
>>
>>Right-click on the button border, and choose Assign Macro.
>>
>>
>>BellExcel wrote:
>>
>>>I have a problem in trying to assign a macro to a button in Excel 2002. When
>>>I create the button, and then click on the button, the "Assign Macro" command
>>>is grayed out (unavailable). I cannot figure out what's wrong.
>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[BellExcel]

Thanks so much! Using the Forms toolbar made the difference!

"Debra Dalgleish" wrote:

> The Assign Macro command will only appear if the button is from the
> Forms toolbar.
>
> If you used a button from the Control toolbox, you shouldn't see Assign
> Macro in the shortcut menu. To run a macro when a button from the
> Control toolbox is clicked:
>
> In Design mode, double-click the button
> Where the cursor is flashing, type the name of the macro you want to
> run. For example:
>
> Private Sub CommandButton1_Click()
> MyMacro
> End Sub
>
>
> Close the Visual Basic Editor.
>
>
>
> BellExcel wrote:
> > For some reason, this does not seem to work for me. Should I be in the
> > control box design mode? I would think so, but the assign macor option does
> > not appear. Should I choose "Command Button Object" and then "Edit".
> >
> > "Debra Dalgleish" wrote:
> >
> >
> >>When you click on the button, click on its border. Around the button,
> >>you'll see a thick dotted border.
> >>(If you click inside the button, you'll see a thick border with diagonal
> >>lines, and you won't be able to assign a macro.)
> >>
> >>Right-click on the button border, and choose Assign Macro.
> >>
> >>
> >>BellExcel wrote:
> >>
> >>>I have a problem in trying to assign a macro to a button in Excel 2002. When
> >>>I create the button, and then click on the button, the "Assign Macro" command
> >>>is grayed out (unavailable). I cannot figure out what's wrong.
> >>
> >>
> >>--
> >>Debra Dalgleish
> >>Excel FAQ, Tips & Book List
> >>http://www.contextures.com/tiptech.html
> >>
> >>
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>