SheetBeforeDoubleClick Event

See Also         Example         Applies To

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

Syntax

Private Sub object_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, ByVal Cancel As Boolean)

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.