Dropdown Sub Menu
 

Is there any way to edit or remove the options available from the Sub menu
toolbar( The one that is available, when you right click a Cell in a
worksheet.)
It would be useful to have a shortened list of options.
Thanking you in anticipation
GJ

Dropdown Sub Menu
 

Try this...

CommandBars("Cell").Controls("Cut").Delete
'To delete "Cut"


CommandBars("Cell").Reset
'To reset everything in the sub menu
--
Regards,
Rocky McKinley


"GJ" wrote in message
...
Is there any way to edit or remove the options available from the Sub menu
toolbar( The one that is available, when you right click a Cell in a
worksheet.)
It would be useful to have a shortened list of options.
Thanking you in anticipation
GJ

Dropdown Sub Menu
 

Thanks Rocky! It all seems so simple when you know how.

"Rocky McKinley" wrote:

Try this...

CommandBars("Cell").Controls("Cut").Delete
'To delete "Cut"


CommandBars("Cell").Reset
'To reset everything in the sub menu
--
Regards,
Rocky McKinley


"GJ" wrote in message
...
Is there any way to edit or remove the options available from the Sub menu
toolbar( The one that is available, when you right click a Cell in a
worksheet.)
It would be useful to have a shortened list of options.
Thanking you in anticipation
GJ