Disable Right-click

[WJReid]

Hi All,

Can anyone give me the code to disable the Right-click toolbar?

Thanks in advance for any help.

Regards,

Bill

 

[smozgur]

Hi Bill,

May be this helps without a macro. Open your form in design mode and goto Properties window and Other tab "Shortcut Menu" property : set is as No.

If you want to control this in VBA then:

  FormName.ShortcutMenu = False

I hope it helps.
Suat

 

[WJReid]

Hi Suat,

Thank you very much for the reply. I am actually looking to disable the Right-click on a Worksheet, not a Form. Sorry, I should have made that clearer at the outset.


Regards,

Bill

 

[smozgur]

Hi Bill,

I thought that it is Access question.

For worksheet object, you can goto worksheet class module and cancel the right click in Worksheet's BeforeRightClick event.

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

Suat

 

[WJReid]

Hi Suat,

Thank you very much for your help. You were correct in thinking that it was an Access question. I needed to disable the right-click in both Access and Excel and should have put the question in both forums. I got the Forums mixed up and was thinking that I was in the Excel Forum.

Thank you once again, your infomation is perfect.

Regards,

Bill