NamedRange.BeforeDoubleClick Event
Visual Studio 2012
Occurs when a NamedRange control is double-clicked, before the default double-click action.
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Double-clicking overlapping NamedRange controls raises the event on each of the controls that overlap.
The following code example creates a NamedRange and then populates all the cells with the text Delete. To test the events, right-click one of the cells to make a border appear around the range, and then double-click one of the cells to clear the range.
This version is for a document-level customization.
Microsoft.Office.Tools.Excel.NamedRange clickRange; private void ClickToChangeRange() { clickRange = this.Controls.AddNamedRange( this.Range["B2", "D4"], "clickRange"); clickRange.Value2 = "Delete"; clickRange.BeforeDoubleClick += new Microsoft.Office.Interop.Excel. DocEvents_BeforeDoubleClickEventHandler( clickRange_BeforeDoubleClick); clickRange.BeforeRightClick += new Microsoft.Office.Interop.Excel. DocEvents_BeforeRightClickEventHandler( clickRange_BeforeRightClick); } void clickRange_BeforeRightClick( Excel.Range Target, ref bool Cancel) { clickRange.BorderAround(missing, Excel.XlBorderWeight.xlThick, Excel.XlColorIndex.xlColorIndexAutomatic); Cancel = true; } void clickRange_BeforeDoubleClick( Excel.Range Target, ref bool Cancel) { clickRange.Clear(); Cancel = true; }
This version is for an application-level add-in.
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.
