ContextMenu for table xml excel

Question

Today, I was looking for a method for customize contextual menu in excel. I found this topic useful:

http://www.rondebruin.nl/win/s6/win001.htm

However in the following XML code, this snnipet idMso="ContextMenuCell" doesn't work under any circumstances. I spent several hours looking for a table object id for idMso.

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
   <contextMenus>
      <contextMenu idMso="ContextMenuCell">
         <dynamicMenu id="MyDynamicMenu" 
        label= "My Dynamic Menu" imageMso="HappyFace" 
        getContent="GetContent" insertBeforeMso="Cut"/>
      </contextMenu>
   </contextMenus>
</customUI>

Providing an answer to your own question is completely okay and also often quite useful. However, you should not answer in the question; post your answer as a separate answer instead. The question should really only contain the question. — morxa
– morxa, Commented Mar 22, 2016 at 19:49

MIchael G. · Accepted Answer · 2016-04-28 13:40:09Z

7

Try using idMso="ContextMenuListRange" for excel table context menu modification.

answered Apr 28, 2016 at 13:40

MIchael G.

712 bronze badges

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

1 Comment

Scott Stafford Over a year ago

That worked. Is there documentation anywhere, or are you just supposed to guess?

Collectives™ on Stack Overflow

ContextMenu for table xml excel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related