SheetBeforeRightClick Event [Excel 2003 VBA Language Reference]

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

Private Subobject**_SheetBeforeRightClick(ByValShAs Object**, ByValTargetAs Range, ByValCancelAs Boolean)

objectApplication 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 right-click occurred.

CancelFalse 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

Applies to | Application Object | Workbook Object

See Also | BeforeDoubleClick Event | BeforeRightClick Event | SheetBeforeDoubleClick Event