| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Execute My Code on Menu Option
hi, Mike !
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... you probably need to use a class module, see this thread: http://tinyurl.com/6po44f hth, hector. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Execute My Code on Menu Option
I got it to work. Thanks!
"Héctor Miguel" wrote: hi, Mike ! 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... you probably need to use a class module, see this thread: http://tinyurl.com/6po44f hth, hector. |
| Reply |
| 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 | |||
Hybrid Mode
