How do I Assign Macro to a button?

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

Guest

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.
 
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.
 
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".
 
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.
 
Back
Top