Syntax
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Enter
Code
End Sub
This event will run after a user double
clicks within any of the worksheets in this specific workbook. This event will occur
after the Worksheet SheetBeforeDoubleClick Event for the worksheet that is
double clicked.
Required Parameters
Sh
The sh parameter returns the worksheet that
was double clicked by the user. This
parameter returns a Worksheet object to allow users to manipulate the events,
methods and properties.
Target
The target parameter will return the range of
the cell closest to where the mouse is pointing when the double click occurs.
Cancel
The cancel parameter is Boolean data type set
to return either true or false. By
default the cancel parameter will return a value of false when the double click
occurs. If the cancel parameter is set to a value of True then the default
double click process will not occur.
