VSTO Excel Addin

Add-in Express™ Support Service
That's what is more important than anything else

VSTO Excel Addin
Block "Send To" menu click event of Excel workbook 
Ragu Raman




Posts: 2
 Joined: 2008-05-13
Hi,

I want to block sending a workbook thro mail from Excel itself.
i.e.
File
-> Send To - > Mail Receipient

What is the event associate with the "Send To" menu click action
or is there any other way to capture the click event of "Send To" mail
in Excel

For Excel Addin there are some of the event as like
a. AppEvents_WorkbookActivateEventHandler
b. AppEvents_WorkbookBeforeCloseEventHandler
etc.
like that what is the event for sending mail.

Or How could i achieve this , in any other way(other than macros) using VSTO Excel Addin

Note : Macro's should not be used here.
Posted 13 May, 2008 03:31:34 Top
Sergey Grischenko


Add-in Express team


Posts: 7228
 Joined: 2004-07-05
Hi Ragu.

You need to use the OnActionEx event handler of the ADXBuiltInControl component to disable the standard action of the built-in control. The Id of the 'Send To -> Mail Receipient' item is 3738.
Posted 13 May, 2008 07:15:15 Top
Ragu Raman




Posts: 2
 Joined: 2008-05-13
Hi Sergey,
Is this event handler is for Office version 2003? because i am using office version 2003.


I tried to search for this "OnActionEx" event handler of the ADXBuiltInControl component. I was not able to get exact result from MSDN and also in google.

If possible please refer me a link where i can get articles and coding snippets regarding this.

Please suggest.

Thanks.
Posted 13 May, 2008 10:37:41 Top
Sergey Grischenko


Add-in Express team


Posts: 7228
 Joined: 2004-07-05
Ragu, the ADXBuiltInControl component is the component defined in the Add-in Express library. Please add the component to the addinmodule and double click on the ActionEx event in the Properties window.
Posted 13 May, 2008 11:19:56 Top