Associating a macro with a button

  • Thread starter Thread starter Shawn Weidmann
  • Start date Start date
S

Shawn Weidmann

In Excel 2000 I could right-click on a button and it
would give me the option of recording a macro to execute
with the button but now in Excel 2002 it no longer gives
me this option. How do I associate a macro with a button
in 2002?
 
Hi

I don't have Excel 2002, but in Excel 97 you have to use a button from the
Forms toolbar, not the Control toolbar to do that.


HTH

Ken
 
First of all you could delete the old macro first.
You do that by pressing Alt+F11 and enter one the module. Probably name
Module1 if its a single macro.
Then delete the text in there and leave the sheet. Now you should be
able to right click it again and assign a new macro.

Rune Daub
 
Back
Top