Assign Macro to Command Button

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

Guest

How do I assign a macro to a command button in Excel 2003. Previously it was
just a right-click away, but not any more:(

Thankx
 
Hi adamaagard

You have add a button from the control toolbox instead one from the forms toolbar.

This button have a click event.
Double click on the button when you are in design mode and
enter the macro name in the click event
 
Hi,
i have xp but:
- for a CommandButton from the Control Toolbox toolbar, say CommandButton1,
you have to create an event sub in the sheet (or userform) containing the
control:
Private Sub CommandButton_Click( )
End Sub
- for a Button from the Forms toolbar, Right-Click on the button and choose
Assign Macro from the pop-up menu.
 
Back
Top