how to share the ribbon with multiple .xlam

**sezb51** · 02-07-2009

Hello,

in excel 2007 I developed three applications each with his own ribbon group.

1st .xlam:

HTML Code:

<tab id="Claimtool-tab" label="Claim Tool">
 <group id="Claimtool-group" label="Claim Tool">
 <...>
 </group>
</tab>

2nd .xlam:

HTML Code:

<tab id="Pricetool-tab" label="Price Tool">
 <group id="Pricetool-group" label="Price Tool">
 <...>
 </group>
</tab>

3rd .xlam:

Code:

<tab id="SearchTool-tab" label="Search Tool">
 <group id="SearchTool-group" label="Search Tool">
 <...>
 </group>
</tab>

Now I would like to have those three to reuse a same "<tab id=" like for example "myTools". I tried the following:

1st .xlam:

Code:

<tab id="myTools" label="My Tool">
 <group id="Claimtool-group" label="Claim Tool">
 <...>
 </group>
</tab>

2nd .xlam:

Code:

<tab id="myTools" label="My Tool">
 <group id="Pricetool-group" label="Price Tool">
 <...>
 </group>
</tab>

3rd .xlam:

Code:

<tab id="myTools" label="My Tool">
 <group id="SearchTool-group" label="Search Tool">
 <...>
 </group>
</tab>

But it doesn't do the trick

I was expecting the three groups to sit in the same "My Tools" menu bar....

Do you have any suggestion ?

Thx!
Andrea

**Pauline** · 03-07-2009

Well, I'm not sure how much help this is, but the mechanism you describe works in principle. In Excel 2002, that is. When you use the CallByName function and the VBGet Call Type constant to programmatically return a chart series or another chart object in a Microsoft Visual Basic for Applications (VBA) macro in Excel 2007. You might try adding a second XLA and XLAM add-in to test XLA->XLA and XLAM->XLAM calls in your version, maybe that'll shed some more light...