Custom Right-Click Menu & Submenu

Hi,

I want to create a right click custom menu so that it only shows the my options. By this I mean that I want to hide or disable the default options.

I know I can disable options this way:

Please Login or Register  to view this content.

It's possible to disable all the default options? How can I get the list of all CommandBars("Cell")?

Regards,
Elio Fernandes

Is this for a specific sheet, or for all workbooks? If it's for a specific sheet, then I would create your own commandbar and show that instead of the default one rather than altering the Cell menus (note: there are two of them).

In the worksheet's code module (right-click the sheet tab, and choose View Code):

Please Login or Register  to view this content.

then in a normal module:

Please Login or Register  to view this content.

adjust the number of controls and macro names as required.

Here's a revised version of the original code - it adds two buttons, then a submenu with another two buttons:

Please Login or Register  to view this content.