Workbook.SheetBeforeDoubleClick event (Excel)
Occurs when any worksheet is double-clicked, before the default double-click action.
Syntax
expression.SheetBeforeDoubleClick (Sh, Target, Cancel)
expression An expression that returns a Workbook object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Sh | Required | Object | A Worksheet object that represents the sheet. |
| Target | Required | Range | The cell nearest to the mouse pointer when the double-click occurred. |
| Cancel | Required | Boolean | False when the event occurs. If the event procedure sets this argument to True, the default double-click action isn't performed when the procedure is finished. |
Remarks
This event doesn't occur on chart sheets.
Example
This example disables the default double-click action.
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, _
ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.