I have multiple excel add-ins that I want showing up in a custom ribbon drop down menu. I can easily add the first item to the menu, but the second one creates another ribbon tab by the same name. Can I merge them? How?
Thanks.
I have multiple excel add-ins that I want showing up in a custom ribbon drop down menu. I can easily add the first item to the menu, but the second one creates another ribbon tab by the same name. Can I merge them? How?
Thanks.
Did you declare a shared namespace?
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" xmlns:Q="Shared Namespace">
Last edited by Aussiebear; 04-15-2023 at 03:12 AM. Reason: Adjusted the code tags
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks for your reply. I've got it to the point where the second xlam appears within the drop down menu of the first using the following XML for both. However, the image does not appear when I change menu id to idQ. If I change the idQ back to id, or if I change custom image to imageMso, it works fine. Is there a better way to do this so that I can use my custom image?
First Add-in:
Second Add-in:<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" xmlns:x="myNameSpace"> <ribbon> <tabs> <tab idQ="x:GabeTab" label="RehabCalcs" insertAfterMso="Add-Ins"> <group id="customGroup1" label="Prescription"> <button id="customButton1" size="large" onAction="OpenCalc" image="Rx2" /> </group> <group idQ="x:customGroup2" label="Exercises"> <menu idQ="x:MyDropdownMenu" size="large" image="Ex2" > <button id="customButton2" label="Postures" onAction="Postures" /> </menu> </group> <group idQ="x:customGroup3" label="Assessment"> <menu idQ="x:MyDropdownMenu2" size="large" image="Ax2" > <button id="customButton3" label="Ax1Button" onAction="Macro1" /> </menu> </group> </tab> </tabs> </ribbon>
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" xmlns:x="myNameSpace"> <ribbon> <tabs> <tab idQ="x:GabeTab" label="RehabCalcs" insertAfterMso="Add-Ins"> <group idQ="x:customGroup2" label="Exercises"> <menu idQ="x:MyDropdownMenu" size="large" image="Ex2" > <button id="customButton4" label="Two" onAction="Postures2" /> </menu> </group> <group idQ="x:customGroup3" label="Assessment"> <menu idQ="x:MyDropdownMenu2" size="large" image="Ax2" > <button id="customButton5" label="Yup" onAction="Macro2" /> </menu> </group> </tab> </tabs> </ribbon> </customUI>