WorkbookBase.SheetBeforeDoubleClick Event

Occurs when any worksheet is double-clicked, before the default double-click action.

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

Syntax

'Declaration
Public Event SheetBeforeDoubleClick As WorkbookEvents_SheetBeforeDoubleClickEventHandler

public event WorkbookEvents_SheetBeforeDoubleClickEventHandler SheetBeforeDoubleClick

Remarks

This event does not occur on chart sheets.

Examples

The following code example demonstrates a handler for the SheetBeforeDoubleClick event. The event handler informs the user that double-clicking is not allowed for the worksheet, and then sets the Cancel parameter of the WorkbookEvents_SheetBeforeDoubleClickEventHandler event handler to true so that Microsoft Office Excel cancels the double-click action.

This example is for a document-level customization.

Sub ThisWorkbook_SheetBeforeDoubleClick(ByVal Sh As Object, _
    ByVal Target As Excel.Range, ByRef Cancel As Boolean) _
    Handles Me.SheetBeforeDoubleClick

    MsgBox("Double-clicking in " & CType(Sh, Excel.Worksheet).Name & _
        " is not allowed.")
    Cancel = True
End Sub

private void WorkbookSheetBeforeDoubleClick()
{
    this.SheetBeforeDoubleClick +=
        new Excel.WorkbookEvents_SheetBeforeDoubleClickEventHandler(
        ThisWorkbook_SheetBeforeDoubleClick);
}

void ThisWorkbook_SheetBeforeDoubleClick(object Sh,
    Excel.Range Target, ref bool Cancel)
{
    MessageBox.Show("Double-clicking in " + ((Excel.Worksheet)Sh).Name +
        " 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

WorkbookBase Class

Microsoft.Office.Tools.Excel Namespace