Excel 2007 Disable right click menu items

[neodjandre]

Hello,

I was wondering how can someone disable right click menu items in EXCEL 2007.

Specifically, I would like to disable the 'Format Shapes' item from all right click menus for any types of shapes.

thanks

crosspost: http://www.mrexcel.com/forum/showthread.php?t=331677&highlight=click+2007

[Paul_Hossler]

In the CustomUI, I think you need to set the idMso you want to false.

These are from a sample in the CustomUI editor


<!-- Disable Save As in the Office button menu and also the splitbutton menu-->
<command idMso="FileSaveAs" enabled = "false" />
<command idMso="FileSaveAsMenu" enabled = "false" />
<!-- Example to disable the MergeCenterMenu on the Home tab in the Alignment group-->
<command idMso="MergeCenterMenu" enabled = "false" />


Paul