Workbook.SheetBeforeRightClick Event (Excel)
Occurs when any worksheet is right-clicked, before the default right-click action.
Syntax
식 .SheetBeforeRightClick(Sh, Target, Cancel)
식 An expression that returns a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Sh |
필수 |
Object |
A Worksheet object that represents the sheet. |
Target |
필수 |
Range |
The cell nearest to the mouse pointer when the right-click occurred. |
Cancel |
필수 |
Boolean |
False when the event occurs. If the event procedure sets this argument to True, the default right-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 right-click action. For another example, see the BeforeRightClick event example.
Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, _
ByVal Target As Range, ByVal Cancel As Boolean)
Cancel = True
End Sub