Excel Context Menu Not Showing

Question

I am using the "Custom UI Editor For Microsoft Office". I have added an "Office 2007 Custom UI Part" which creates the "customui.xml" file for me. It currently has the following code which adds my "Zoom Cell" button to the developer tab.

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">  
  <ribbon>  
    <tabs>  

      <tab idMso="TabDeveloper" >  
        <group id="customGroup1" label="Zoom" insertAfterMso="GroupModify">  

          <button id="customButton1" label="Zoom Cell" size="large" onAction="ZoomCell" imageMso="ZoomPrintPreviewExcel" />

        </group>  
      </tab>  

    </tabs>  
  </ribbon>
</customUI>

What I am trying to do is add the same button basically to the context menu for right-clicking on a cell; however, it is not working for me. If I modify the code even the button from the above code gets removed. Here is what I have tried. I am pretty sure that there is something weird in my xml code; I just can't find it.

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">  
  <ribbon>  
    <tabs>  

      <tab idMso="TabDeveloper" >  
        <group id="customGroup1" label="Zoom" insertAfterMso="GroupModify">  

          <button id="customButton1" label="Zoom Cell" size="large" onAction="ZoomCell" imageMso="ZoomPrintPreviewExcel" />

        </group>  
      </tab>  

    </tabs>  
  </ribbon>
  <contextMenus>
   <contextMenu idMso="ContextMenuCell">
    <button id="MyButton" label="Zoom Cell" onAction="ZoomCell" imageMso="ZoomPrintPreviewExcel" insertBeforeMso="Cut" />
   </contextMenu>
  </contextMenus>
</customUI>

David Zemens · Accepted Answer · 2014-07-08 22:16:40Z

1

When I put your code in the CustomUI Editor and try to validate it, I get an error that "contextMenus" is not supported element in the CustomUI namespace, followed by a list of expected/allowable elements:

enter image description here

Allowable elements are:

qat
officeMenu
contextualTabs

It seems from THIS LINK (which is for Outlook, but I believe the approach would be same/similar for Excel/etc.) that context Menus are manipulated through VBA events in Office 2007.

I think that RibbonUI manipulation of context menus was not introduced until 2010.

answered Jul 8, 2014 at 22:16

David Zemens

53.8k12 gold badges86 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel Context Menu Not Showing

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related