View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default worksheet_beforerigthclick event

Is the code behind the correct worksheet?

Have you disabled events and not re-enabled them?



"R..VENKATARAMAN" wrote:

I have a code like this

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
Target.Offset(0, 1) = Target

End Sub

in spite of cancel=true statement when I right click the target, the submenu
comes up and so the event code does not work. where is the mistake.


--

Dave Peterson