Custom Ribbon Menu Tab Group in 2013

[vthokienj]

I have a file where I create my own custom tab group using the Custom UI Editor. The tab group does not display when opened with Excel 2013.
I've read about the differences between 2007 and 2010/2013 and it seems like there should be no issue with this file. The XML code is added an an 'Office 2010 Custom UI Part' so it is in the customUI14.xml file, as opposed to the customUI.xml for earlier Excel versions.

The code I am using is below. If I put this code in the customUI.xml and change the 2009/07 part to 2006/01 it displays correctly in Excel 2007.

Thanks for any help.

<!--?xml version="1.0" encoding="utf-8" ?--><Z?xml version="1.0" encoding="utf-8" ?>
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" >
  <ribbon startFromScratch="true">
    <tabs>
      <tab id="tabMyCustomCharts" label="My Charts">

        <group id="groupCriteria" label="Charts">
          <button id="btnObjectives" label="Objectives"
                  image="charts" size="large"             
                  onAction="RibbonMenuCharts_ClickHandler" />
        </group>

      </tab>
    </tabs>
  </ribbon>
</customUI>

 

[VBA Geek]

hello, the xml you provided doesn't help identify potential issues, you should post the entire xml

 

[vthokienj]

I don't know how you post XML code, or if you can, without it actually running it. So the below is the code, with the brackets replaced by ZZ.

ZZ?xml version="1.0" encoding="utf-8" ?ZZ
ZZcustomUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" ZZ
  ZZribbon startFromScratch="true"ZZ
    ZZtabsZZ
      ZZtab id="tabMyCustomCharts" label="My Charts"ZZ

        ZZgroup id="groupCriteria" label="Charts"ZZ
          ZZbutton id="btnObjectives" label="Objectives"
                  image="charts" size="large"             
                  onAction="RibbonMenuCharts_ClickHandler" ZZ
        ZZgroupZZ

      ZZtabZZ
    ZZtabsZZ
  ZZribbonZZ
ZZcustomUIZZ

 

[VBA Geek]

I don't know how you post XML code, or if you can, without it actually running it. So the below is the code, with the brackets replaced by ZZ.

try to go to advanced and post it using PHP brakets

 

[vthokienj]

Thanks for the suggestion, that works.

<!--?xml version="1.0" encoding="utf-8" ?-->

<?xml version="1.0" encoding="utf-8" ?>
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" >
  <ribbon startFromScratch="true">
    <tabs>
      <tab id="tabMyCustomCharts" label="My Charts">

        <group id="groupCriteria" label="Charts">
          <button id="btnObjectives" label="Objectives"
                  image="charts" size="large"             
                  onAction="RibbonMenuCharts_ClickHandler" />
        </group>

      </tab>
    </tabs>
  </ribbon>
</customUI>

 

[VBA Geek]

The tab group does not display when opened with Excel 2013.

hi, just tested on Excel 2013 and the tab is getting displayed...

 

[vthokienj]

Thanks. I have tested it on two different machines and it does not work on either. This makes me think there is a setting somewhere that prevents it from displaying.

 

[starl]

Are you writing the XML from scratch? I prefer (and recommend) the Ribbon Editor by Andy Pope (Ribbon Editor 2010) - less chance of errors. Though I do believe understanding the code is important in case you run into an error (for example, if you take older XML and try to modify via the addin, you may get problems that can only be fixed manually).
To troubleshoot -go to the File tab and select Options, Advanced, General, and select Show Add-In User Interface Errors. This will allow error messages to appear so that you can troubleshoot errors in your custom toolbar.

 

[vthokienj]

I am writing from scratch and will try Andy's tool.

I have since tested the same file on multiple machines and have determined that on four systems with Excel 2013 it works as expected on two and does not on the other two. Macros are enabled and I don't see any settings that would prevent the ribbon from loading, but this issue is also impacting a commercial program as well (Palisade @Risk). So it seems there is a setting in Excel or something external that may be preventing the ribbon from loading.

 

[AkaTrouble]

the line <customui xmlns="http://schemas.microsoft.com/office/2009/07/customui<font color=" #ff0000"="">" >

<customui xmlns="http://schemas.microsoft.com/office/2009/07/customui">has a space at end not sure if this would cause error on my custom menu it has no space

my line

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">

<customui xmlns="http://schemas.microsoft.com/office/2009/07/customui">



only a guess</customui></customui></customui>

several edits to get line to show sorry