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
|