macro for right click

[kalpesh]

Hello

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

please help me

 

[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

right click sheet tab>view code>insert this

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