Hello, I tried this code but it doesnt work at all. I'm using excel 2010 but I can still right click. Any ideas why I'm still able to right click?
This doesnt work either:
Code:
Private Sub Worksheet_BeforeRightClick()
Val Target As Range, Cancel As Boolean
If Target = "A1" Then
Cancel = True
End If
End Sub
This doesnt work either:
Code:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
MsgBox ("Sorry Right Click is Disbaled for this Workbook")
End Sub