Stop menu from showing when right clicking on cell

[griselda]

Hi

In an excel sheet, I would like to run a routine when rightclick is done.
By using Sub Worksheet_BeforeRightClick, the right click is detected and my code is run, however after code is done, the right click menu shows up (delete, paste, etc)

I would like to stop the menu from showing after the code is finished.

How do I do this ?

thanks in advance

 

[VoG]

Like this

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
'
'your code
'
End Sub

 

[griselda]

ahhhhh !

so easy !!!

thank you so much !