View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default 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.