| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding command button to menu
Sub AddMacro()
Set bar = CommandBars("Standard") Set ctl = bar.Controls _ .Add(Type:=msoControlButton) ctl.Caption = "Run my macro" ctl.Style = msoButtonCaption 'Macro to run ctl.OnAction = "MyMacro" End Sub -- urkec "excel-tr" wrote: Hi, how can I add a command button to standart excel toolbar.When I click it a macro will work. regards. -- SAHRAYICEDIT-ISTANBUL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Placing a Command Button in a New Tool Menu | Excel Discussion (Misc queries) | |||
| Command Button Created from Forms Menu Question | Excel Programming | |||
| Using code from custom menu bar to a Command button | Excel Programming | |||
| Command/option/spin button - no control menu available | Excel Programming | |||
| Adding toolbar/menu command to Excel using C# | Excel Programming | |||
Linear Mode
