How Could i assign a botton to a macro on ms excel? (URGENT)?

Question

I recorded the macro and i can use it by the short cut on the keyboard... and i did draw the botton... but i really do not know how can i make the macro run just by clicking over the botton ... please help.. thnx

Answer 1

If not
I guess you created the button from Tools > Toolbars > Forms

If so, then
Right click on it and select "Assign macro"

That is it

Enjoy my profile, I am the VBAXLMan

Answer 2

You probably have a button from the control toolbox. Delete(Cut) that button and draw a button from the Forms toolbox. It will ask you to assign a macro when you draw it onto your sheet. Assign your macro.