Macro Button

J

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

J.E. McGimpsey

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

Eric

Jaime

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

Eric
 
P

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

Eric said:
Jaime,

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