Attach Macro to button?

[Guest]

I know how to design a button, and I know how to record a macro but I can't
figure out how to attach the macro to the button?

 

[David Hilberg]

Are you using xl2003 or earlier? Is the button on a command bar (not
embedded in a sheet)? If yes to both:

Tools > Customize
Right Click the button
Choose "Assign Macro"

- David

 

[Guest]

Using XL2003. The button is my designed embedded in the worksheet.

 

[Guest]

One way to do it is to call it via the click event:

Private Sub CommandButton1_Click() 'Or whatever name
myMacro 'Your macro name here if it is in the standard module
End Sub

If your macro is in a sheet you might have to use Run (macro name)