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
|