Occurs when any worksheet is double-clicked, before the default double-click action.
Syntax
expression.SheetBeforeDoubleClick (Sh, Target, Cancel)
expression An expression that returns an Application 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.