Associating a macro with a button

[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?

 

[Ken Macksey]

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

 

[Rune_Daub]

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