View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default macro for right click

On Feb 12, 11:23*am, kalpesh
wrote:
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 tabview codeinsert this

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