Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Associating a macro with a button
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Associating a macro with a button
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Associating a macro with a button
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Associating a Name with a Number | Excel Discussion (Misc queries) | |||
Associating Tab Names to Cells | Excel Discussion (Misc queries) | |||
Associating highest value with name | Excel Discussion (Misc queries) | |||
Associating a Radio Button to a Value | Excel Discussion (Misc queries) | |||
Associating one array with another | Excel Programming |