disable right click on mouse

[jatman]

is it possible to disable the right click (copy/cut/paste) on a mouse in
excel spreadsheet.

jatman

 

[Gord Dibben]

In the Immediate Window of the VBE

Application.CommandBars("Cell").Enabled = False 'True to reset

You may want it disabled for one worksheet but not another or one workbook and
not others.

Post back with more details if you want something tailored.


Gord Dibben MS Excel MVP

 

[Jim Rech]

Application.Commandbars("Cell").Enabled = False

disables the menu completely. Be sure to enable it or the user will be
stuck with it this way.

Another option is just to disable it on a specific sheet:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
End Sub

This must be pasted into the sheet's module (right click sheet tab and click
View Code.

Or for an entire workbook:

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

Pasted into the ThisWorkbook module.