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? |
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 |
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/ |
All times are GMT +1. The time now is 02:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com