Excel 2010 Controls Question

[aquixano]

Does anyone know when you add a tab to the Ribbon using the onboard Excel Ribbon Customization functionality what Control Name is assigned to the new Tab?
I’m working on customizing my Ribbon in Excel 2010 using Ron de Bruin’s website and I’ve found how you can add a custom group to either an Existing Excel Tab or to a custom group also created with XML.
I’ve downloaded the ExcelControls.xlsx help file and see that the existing tabs have the following Control Names:
TabHome
TabInsert
TabPageLayoutExcel
TabFormulas
TabData
TabReview
TabView
TabDeveloper

The Tab I created using the Customize Ribbon functionality (Not XML) is called “Trades” I’ve tried:
Trades
TabTrades
TabTradesExcel

None of them work (i.e. the custom RDB group example which I can display on TabHome, etc. does not display on Trades.) I suspect the Control name is off. I tried turning on the macro recorder and changing tabs, but that action isn’t captured by the recorder. Searching for changing the Tabs in VBA only turns up SendKeys code. Anyone have any idea how I can find what Control Name Excel is using with my Custom Tab? Thanks for reading & any help.

[Logit]

.
Try:

Please Login or Register  to view this content.

[aquixano]

Thanks for your reply.
This is the existing line of XML codes which validates (but does not work)
<tab idMso="Trades" >

When I modified it to include the &
<tab idMso="&Trades" >

I get the following error: “Not a valid XML document! “” is an unexpected token. The expected token is’;’. Line 11, position 26.

So I added the semicolon:
<tab idMso="&Trades;" >

Now the error is “Not a valid XML document! Reference to undeclared entity ‘Trades’. Line 11, position 20.

This last one sounds like I’m getting close – maybe missing a declaration statement of some type – any ideas?

[aquixano]

fyi - the excelforum stripped out the leading spaces on the code lines. Position 20 in the last error is the "T" in Trades

[Logit]

My suggestion was based on syntax for most menu 'commands' in VBA / VB.
I wish I could be of more assistance but my knowledge level in this area (your project) is very limited.
Hopefully a Forum Guru will be of assistance.

Best wishes.

[xlnitwit]

Hi,

idMso is only for the built in controls. You use id for custom controls/tabs- or idQ if you need to share them between workbooks. I am not certain whether that will work with a tab manually created in the UI as I do not know in which order the customisations are loaded. Typically the tab would also be created in the CustomUI part if it is a custom tab.