Loop Through Ribbon Using VBA? (need IDs for custom add-in(s))

[elthombre]

Hi All,

I was wondering if it is possible to loop through all controls in the Ribbon, including custom add-ins, and get the IDs?

What I am ultimately trying to do is add a control group to a tab which is not from native Excel but another add-in that I do not have source to. If I can get the IDs, I can update custom XML.

Thanks

 

[Dan_W]

Hi All,

I was wondering if it is possible to loop through all controls in the Ribbon, including custom add-ins, and get the IDs?

What I am ultimately trying to do is add a control group to a tab which is not from native Excel but another add-in that I do not have source to. If I can get the IDs, I can update custom XML.

Thanks

Do you have access to the custom XML of the tab you're trying to replicate? I'm guessing perhaps not...?

 

[elthombre]

Do you have access to the custom XML of the tab you're trying to replicate? I'm guessing perhaps not...?

No. There is a file: Excel.officeUI which can be edited but, for now, we're bagging this.