macro for right click

K

kalpesh

Hello

i nee a macro to restrict right click option
eg, in sheet 1 do not allow right click optio

please help me
 
D

Don Guillett

Hello,

 i nee a macro  to  restrict right click option.
 eg,  in sheet 1 do not allow right click option

 please help me
Click to expand...
right click sheet tab>view code>insert this

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