You can assign macros in the way you want to buttons created from the
Forms toolbar. You've created a button from the Control Toolbox instead.
You can use the button's _Click() event to call your macro:

Sub CommandButton1_Click()
MyMacro
End Sub

In article ,
"Mickey Blue Eyes" <Mickey Blue wrote:

I have created a Macro to perform the task of taking the user from one
worksheet to another upon clicking the command button. However when right
clicking on my mouse to view the short cut menu for the command button there
is no option to assign a macro to the button? The options availabl to me are
the format control at the bottom of the short cut menu. How do I activate a
Macro on a command button??