Please tell me how to disable the shortcut menu

[excelguy2]

Please tell me how to disable (in VBA) the shortcut menu that appeared when I right click the mouse. Thanks

 

[hatman]

There are several ways to do this, depending on preference and scope.

One way to disable this menu throughout an entire workbook is to insert the following code into the ThisWorkbook Class Module.

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

    Cancel = True

End Sub