On the forms (or a shape from the drawing menu)right click the lower
rightwhen you see assign macrojust highlight the macro in the vbe


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Zak" wrote in message
...
I have tried many times to add my macro to a button but it does not work. I
have tried both the control toolbox and the forms menu.

I am in design view when i create the button, double click it to show the
VBE, enter the below code, go back to the button coming out of design view
but nothing happens! not even an error. same when i do it via the forms
menu,
i assign the button but nothing happens!!
(replace is my macros name.)

Private Sub CommandButton1_Click()
Run "replace"

End Sub

please help. thanks.