Probelms customizing Ribbon 1

[LakotaMan]

Hi again all,
This must be my week for Access problems!

Using ver. 2007, I am trying to customize the ribbon as follows:

Don't want any tabs except the Home and External Data tabs.
I have the USysRibbons table all set up,and have a record for a RibbonName: SpreadsheetRibbon and the following code for the RibbonXML:

<customUI xmlns="[URL unfurl="true"]http://schemas.microsoft.com/office/2006/01/customui">[/URL]
   <ribbon startFromScratch="false">
      <tabs>
        <tab idMso="TabHomeAccess" visible="true" />
        <tab idMso="TabExternalData" visible="true" />
      </tabs>
   </ribbon>
</customUI>

After restarting Access entirely and running the form in question (where I have attached the SpreadSheetRibbon to the Ribbon Name property) the Home tab shows up fine, but not the External Data tab.

Any help you can give me will be greatly appeciated.
LM

 

[FancyPrairie]

Try this:
<customUI xmlns="

http://schemas.microsoft.com/office/2006/01/customui">

<ribbon startFromScratch="true">
<tabs>
<tab idMso="TabHomeAccess" visible="true">
</tab>
<tab idMso="TabExternalData" visible="true"
</tab>
</tabs>
</ribbon>
</customUI>

 

[LakotaMan]

FancyPrairie,

Tried your code --that did the trick!

Thanks for your help & have a star.

LM