Disable right click menu from comand button

Dear All,
I Have an excel sheet with many command button for the user to click and use filter. How can I disable the right click menu from the button so that the user will not change any values including resizing.
Thanks in advance to all

You can disable right-clicking on the entire sheet by adding this code to that specific sheet's VBA:

Please Login or Register  to view this content.

-Moo

Dear Moo,
Thanks for you support. I tried this code, its still allow you to right click on shapes and buttons. I want something close to this for command buttons and even to shapes also will do. Thanks again.

The only other way I can think of is to protect the Worksheet. By default, form controls are locked, as are cells in the spreadsheet. If you protected the worksheet and unlocked only the cells a user would need to interact with, it might do what you need.

- Moo

Protect sheet is not allowing to run macros