Error 400 in Custom UI editor ?

[RustyNail]

Hello,

I am trying to display the home tab in the XLM code.

Here's my XLM code:

<customUI onLoad="RibbonX.RibbonOnLoad" xmlns="http://schemas.microsoft.com/office/2006/01/customui">

    <ribbon startFromScratch="true">         

        <officeMenu>            
            <button idMso="FileSaveAs" visible="true" />
        </officeMenu>
        
        <tabs>
            <tab id="customTab" label="CONTROLS" insertAfterMso="TabHome">
                <group id="customGroup4" label="Export options">
                    <button id="customButton8" label="Export" size="large" onAction="Sheet1.ExportLogic" imageMso="DefinePrintStyles" />
                </group>
            </tab>

            <tab idMso="TabDeveloper" getVisible="RibbonX.GetVisible"  />  
            <tab idMso="TabHome" getVisible="true"  />                                <!-- line causing error!!!!! -->
        </tabs>
    </ribbon>
</customUI> 

The following line in the above code causses the "400" error:

<tab idMso="TabHome" getVisible="true" />


Can someone help me to get rid of this error.

Thanking all in advance!
rn

[HerryMarkowitz]

Try this....

<customUI onLoad="RibbonX.RibbonOnLoad" xmlns="http://schemas.microsoft.com/office/2006/01/customui">

    <ribbon startFromScratch="true">         

        <officeMenu>            
            <button idMso="FileSaveAs" visible="true" />
        </officeMenu>
        
        <tabs>
            <tab id="customTab" label="CONTROLS" insertAfterMso="TabHome">
                <group id="customGroup4" label="Export options">
                    <button id="customButton8" label="Export" size="large" onAction="Sheet1.ExportLogic" imageMso="DefinePrintStyles" />
                </group>
            </tab>

            <tab idMso="TabDeveloper" getVisible="RibbonX.GetVisible"  />  
            </tab>
            <tab idMso="TabHome" getVisible="true"  />      
            </tab>                          
        </tabs>
    </ribbon>
</customUI>

[RustyNail]

Hello Henry!

Thanks for replying!

Here's what I tried:

<customUI onLoad="RibbonX.RibbonOnLoad" xmlns="http://schemas.microsoft.com/office/2006/01/customui">

    <ribbon startFromScratch="true">         <!-- To hide full ribbon, uncomment this line and comment the previous line  -->

        <officeMenu>            
            <button idMso="FileSaveAs" visible="true" />
        </officeMenu>
        
        <tabs>
            <tab id="customTab" label="CONTROLS" insertAfterMso="TabHome">
                <group id="customGroup4" label="Export options">
                    <button id="customButton8" label="Export" size="large" onAction="Sheet1.ExportLogic" imageMso="DefinePrintStyles" />
                </group>
            </tab> 
            
            <tab idMso="TabDeveloper" getVisible="RibbonX.GetVisible"  />  
            </tab> 
            <tab idMso="TabHome" getVisible="true"  />  
            </tab> 
        </tabs>
    </ribbon>
</customUI> 

... but unfortunately, I get a Custom UI editor error when validate the script... Here's the error:

Not a valid XML document!
The 'tabs' start tag on line 9 does not match the end tag of 'tab'. Line 17, position 6.

What am I missing???

Thanks for your help .

rn

[HerryMarkowitz]

Useful link for you...
http://www.rondebruin.nl/win/s2/win016.htm

[RustyNail]

This site says basically the same thing you proposed ....

and its not working for me!!!

Does anyone know what needs to be done to show the Home tab after startFromScratch is set to true?

Thanks

[RustyNail]

Never mind !

I figured it out!

[RHPJ]

Do you remember the solution? I am receiving an Error 400 when attempting to loop through a directory of workbooks that contain a custom ribbon.

Any assistance would be greatly appreciated.