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


"Shawn Weidmann" wrote in message
...
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?



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/