Workbook.SheetBeforeDoubleClick Event

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.

Visual Basic for Applications
`Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, _ ByVal Target As Range, ByVal Cancel As Boolean) Cancel = True End Sub`

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