Disable right-click

F

fredbibi49

Hi,

Does someone know how to disable the right-click with a macro.
I would like to prevent the user using copy, past etc... in m
worksheets.

Thank you!

fre
 
F

Frank Kabel

Hi
on a worksheet basis you could use the following code in your worksheet
module:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
cancel=true
End Sub
 
Top