If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Assign Macro to AxtiveX objects
Just started playing with ActiveX Command Buttons, with a
view to adding macro code to them to do simple functions within Excel (Versions 2000 & XP). According to the Help in XP, I should be able to do the following in Design mode: "Right click on the sizing handles of the button, then choose 'Assign Macro' from the shortcut menu." Unfortunately I don't get to see the above entry, so I have been forced to use the 'View code' option, then copy the macro code into the button code. This works ok, but... Why doesn't Excel do what it's Help says it will do? |
#2
|
|||
|
|||
Assign Macro to AxtiveX objects
Roger,
The Assign Macro option is used for command buttons from the Forms toolbar, not the Controls toolbar. For buttons from the latter, use View Code and put your code in the button's Click event procedure. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Roger Trewenack" wrote in message ... Just started playing with ActiveX Command Buttons, with a view to adding macro code to them to do simple functions within Excel (Versions 2000 & XP). According to the Help in XP, I should be able to do the following in Design mode: "Right click on the sizing handles of the button, then choose 'Assign Macro' from the shortcut menu." Unfortunately I don't get to see the above entry, so I have been forced to use the 'View code' option, then copy the macro code into the button code. This works ok, but... Why doesn't Excel do what it's Help says it will do? |
Thread Tools | |
Display Modes | |
|
|