Right Click Event

[danbates]

Hi,

I've just added a right click event to call a macro which works fine but it also it is bringing up the normal cut and paste menu.

How can I disable just the cut and paste menu?

Thanks

Dan

 

[My Aswer Is This]

Where is this right click event.
Is this in a userform activex control sheet or what?

 

[danbates]

It's just on a normal sheet and on any cell but it's restricted to a certain row each time via the cells being locked and protected. Here is my code:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Call BlankOutDRS
End Sub

 

[My Aswer Is This]

OK. I see what you mean.
I have no answer.
Why not use a double click event?
Double click the cell and it does something.

 

[My Aswer Is This]

Example:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 3 Then
Cancel = True
Call BlankOutDRS
End If
End Sub

 

[danbates]

Hi,

That's sorted it. Thank you again

I didn't want to use the double click event because I'm already using that for something else and I am trying to make the sheet as user friendly as possible.

Thank again for your help.

Kind Regards
Dan

 

[My Aswer Is This]

Not sure if you mean you found a answer to the right click problem or just decided to use double click.
If you find a answer to the right click problem let us know.
Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

Hi,

That's sorted it. Thank you again

I didn't want to use the double click event because I'm already using that for something else and I am trying to make the sheet as user friendly as possible.

Thank again for your help.

Kind Regards
Dan

 

[RoryA]

To cancel the default menu, you use the same technique as with the DoubleClick event, namely adding:

Cancel = True

to the code.

 

[My Aswer Is This]

That is nice to know.

I use that on double click but to be honest I really do not know what that means but it works.

To cancel the default menu, you use the same technique as with the DoubleClick event, namely adding:

Cancel = True

to the code.