XmlMappedRange.BeforeDoubleClick Event

Occurs when an XmlMappedRange control is double-clicked, before the default double-click action.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Event BeforeDoubleClick As DocEvents_BeforeDoubleClickEventHandler

event DocEvents_BeforeDoubleClickEventHandler BeforeDoubleClick

Examples

The following code demonstrates a handler for the BeforeDoubleClick event that cancels the double-click action in an XmlMappedRange. The event handler informs the user that double-clicking is not allowed for the XmlMappedRange, and then sets the Cancel parameter of the DocEvents_BeforeDoubleClickEventHandler event handler to true so that Microsoft Office Excel cancels the double-click action. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

Sub CustomerLastNameCell_BeforeDoubleClick(ByVal Target As Excel.Range, _
    ByRef Cancel As Boolean) Handles CustomerLastNameCell.BeforeDoubleClick
    MsgBox("Double-clicking in this range is not allowed.")
    Cancel = True 
End Sub

private void XmlMappedRange_BeforeDoubleClick()
{
    this.CustomerLastNameCell.BeforeDoubleClick += 
        new Excel.DocEvents_BeforeDoubleClickEventHandler(
        CustomerLastNameCell_BeforeDoubleClick);
}

void CustomerLastNameCell_BeforeDoubleClick(Excel.Range Target, 
    ref bool Cancel)
{
    MessageBox.Show("Double-clicking in this range " +
        " is not allowed.");
    Cancel = true;
}

.NET Framework Security

• 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.

See Also

Reference

XmlMappedRange Interface

Microsoft.Office.Tools.Excel Namespace