HunterN
Active Member
- Joined
- Mar 19, 2002
- Messages
- 479
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
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