| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Attaching a macro (module) code to button
Below is a code that creates a button on the Worksheet
menu bar. But how do I programmatically assign module "createbutton" to it? Also where can I find more info about programmaticaly creating buttons on Excel Toolbars? Thanx Todd Huttenstine Application.CommandBars("Worksheet Menu Bar").Controls.Add Type:= _ msoControlButton, ID:=2950, Befo=11 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Attaching a macro (module) code to button
You're looking for the OnAction property.
You can do a help search for commandbar. "Todd Huttenstine" wrote in message ... Below is a code that creates a button on the Worksheet menu bar. But how do I programmatically assign module "createbutton" to it? Also where can I find more info about programmaticaly creating buttons on Excel Toolbars? Thanx Todd Huttenstine Application.CommandBars("Worksheet Menu Bar").Controls.Add Type:= _ msoControlButton, ID:=2950, Befo=11 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Attaching Macro to Cell instead of button? | Excel Discussion (Misc queries) | |||
| Need help with recording a macro, attaching a button | Excel Worksheet Functions | |||
| Assigning a module to a button macro | Excel Discussion (Misc queries) | |||
| Attaching a macro to a VB button on a form | Excel Worksheet Functions | |||
| Macro ignors module code | Excel Programming | |||
![Todd Huttenstine[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
