SheetBeforeDoubleClick Event

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

object   Application or Workbook. For more information about using events with the Application object, see Using Events with the Application Object.

Sh   A Worksheet object that represents the sheet.

Target   The cell nearest to the mouse pointer when the double-click occurred.

Cancel   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, ByVal Cancel As Boolean)
    Cancel = True
End Sub