Using the Ribbon in Excel 2007

[HunterN]

Hi all, I am testing to convert over from Excel 2000 to 2007. I have a lot of applications written in Excel 2000, that have a 'create menu' subroutine that uses a menu sheet to add a new button on the CommandBar. I can open this in 2007 and the application adds the new tab 'Add-Ins'. All my menus are there and sub menus are there.

What I want to do is to make the other tabs be removed.

I made the .rel file look like this:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
<Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties" Target="docProps/app.xml"/>
<Relationship Id="rId2" Type="http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties" Target="docProps/core.xml"/>
<Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml"/>
<Relationship Id="customUIRelID"
Type="http://schemas.microsoft.com/office/2006/relationships/ui/extensibility"
Target="customUI/customUI.xml" />
</Relationships>


I made the customUI file look like this: (I removed the < and /> ).

customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
ribbon startFromScratch="false"
tabs
tab idMso="TabHome" visible="false"

tab IdMso="TabAddins" label="Vet Commands"
tabs
ribbon
customUI


I loaded these into the .zip file of the program. And then renamed it back to .xlsm.


But, it stills shows all the other tabs.

Does anyone see anything that I have wrong?

Thanks, Nancy

 

[Derek Brown]

I have not tested this idea but I wonder whether the line

tab idMso="TabHome" visible="false"

is correct?
I would have expected something like:

tab idMso="TabHome" visible=False

 

[Andy Pope]

If you do not want the other tabs visble then set the startFromScratch="true"

But if you are playing with the ribbonx why not create your own tabs rather than rely on the Add-ins tab, which will include any menus/toolbars from other add-ins.

 

[HunterN]

I would put this inside the xml - startFromScratch="true"
but, then I really have to start from scratch and I don't have time to redo all of the applications I have in Excel before we are moving to 2007. If I keep it as "false" then at least it reads my original 'createmenu' module and moves it under the Add-Ins tab.

Maybe when I have more time I will redo all of them to be 'startfromScratch'.


I was able to get the tab name to change correctly. I had the name of the tab spelled wrong. The correct why to do it is:

tab idMso="TabAddIns" label="New Stuff"


Thanks,

Nancy Hunter