Disable Shift+F10 & context menu key in worksheet


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.
 
Ad

Advertisements

A

Alan

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.
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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top