View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
abcd[_2_] abcd[_2_] is offline
external usenet poster
 
Posts: 52
Default Before RightClick event change

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