View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Before RightClick event change

I don't think that was the OP's question.

Perhaps:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, _
Cancel As Boolean)
If Target.Address = Target.EntireRow.Address Then
Cancel = True
MsgBox "Aha!"
End If
End Sub

--

Vasant


"abcd" wrote in message
...
In fact, the event will always be called for every cell
you must check wich row is the caller once the macro is lauched.

For this purpose you may use the Target given in argument
example:

if not( intersect(Target,Rows(12)) is Nothing ) then
'.... the code
end if