Execute My Code on Menu Option

  • Thread starter Thread starter Mike H.
  • Start date Start date
M

Mike H.

Application.VBE.CommandBars.FindControl(ID:=2188).Execute

If I wish to execute my own function when the user selects the option:
File>Send to>Mail 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.
 
hi, Mike !
Application.VBE.CommandBars.FindControl(ID:=2188).Execute
If I wish to execute my own function when the user selects the option:
File>Send to>Mail 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...
Click to expand...

you probably need to use a class module, see this thread: http://tinyurl.com/6po44f

hth,
hector.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to execute macro when selecting user-defined menu in ribbon 6
Assigning macro buttons to macro code in another file 2
Ribbonx - how to create two ribbons? 4
How to call user defined function (UDF) from custom menu in Excel2003? 3
Face id on custom menu bar. 2
Adding a Custom menu / sub menu 5
further question about XLAM menu- Fluent IRibbon 2
Menu Options 2

Back
Top