Skip to main content

Application.SheetBeforeRightClick event

Table of contents
  1. Syntax
  2. Parameters
  3. Remarks

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


expression.SheetBeforeRightClick (ShTargetCancel)

expression An expression that returns an Application object.


Name Required/Optional Data type Description
Sh Required Object Worksheet object that represents the sheet.
Target Required Range The cell nearest to the mouse pointer when the right-click occurred.
Cancel Required 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.


This event doesn't occur on chart sheets.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>