Macro Button

[Jaime Andersen]

I feel stupid for asking this as there has to be an easy way of doing what I want. I created a macro that would clear a couple of cells. I also inserted a button at the bottom of my worksheet. I want to be able to click on the button and have the macro run. Any ideas?

 

[J.E. McGimpsey]

If the button is from the Forms toolbar, right click the button and
choose Assign Macro.

 

[Eric]

Jaime

I think you actually have to click "Tools/Customize..." first, then right-click the button and select "Assign Macro"

Eric

 

[Peo Sjoblom]

Not really, you drag the button to the sheet and when you release it the
assign macro window pops up, if the button is already there you right click
and select assign macro

--

Regards,

Peo Sjoblom

Jaime,

I think you actually have to click "Tools/Customize..." first, then

right-click the button and select "Assign Macro".