Disable Shift+F10 & context menu key in worksheet

  • Thread starter Thread starter Lurc
  • Start date Start date
L

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.
 
Lurc said:
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.
Click to expand...

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.
 
Back
Top