Disable Shift+F10 & context menu key in worksheet

[Lurc]

Dear all,

In Excel worksheet, I want to disable cell's context menu.

Through VBA script I have disabled mouse right-click action by its event
SheetBeforeRightClick. My question is how can I prevent by keyboard,
Shift+F10 and windows context menu key?

Thanks.

 

[Alan]

Dear all,

In Excel worksheet, I want to disable cell's context menu.

Through VBA script I have disabled mouse right-click action by its
event SheetBeforeRightClick. My question is how can I prevent by
keyboard, Shift+F10 and windows context menu key?

Thanks.

Hi,

Try this:

Application.CommandBars("Cell").Enabled = False

I don't think you'll need anything else (such as the event capture) if
you just disable using that command.

HTH,

Alan.

 

[Lurc]

It works. Thanks Alan.