| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execute My Code on Menu Option
Application.VBE.CommandBars.FindControl(ID:=2188). Execute
If I wish to execute my own function when the user selects the option: FileSend toMail Receipient (as attachment)... the Correct ID # is 2188, but how do I tell it to run "MySub" instead? The above line gives me an error # 1004. Perhaps the OnAction will work, but I don't understand the syntax for it. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to assign PRINT option to execute a macro | Excel Discussion (Misc queries) | |||
| Execute code from book1 of code from book2 | Excel Programming | |||
| ENTER keys to execute code to add menu | Excel Programming | |||
| Code won't execute... | Excel Programming | |||
| Execute a menu command with VBA? | Excel Programming | |||
Threaded Mode
