Excel 2007 Ribbon file extension

[Dennis]

With Excel10 the toolbar was a *.xlb file extension. What is the extension
of the ribbon in Excel 2007. I customize my home computer then send the file
to my work machine.

Thanks,
D

 

[iliace]

You can create an .xlam file to put in XLSTART directory, that
contains the code for the ribbon. Ribbon modifications are actually
part of a workbook, and not in a separate file.

 

[Dennis]

Are they part of the personal.xls file then?

Thanks
Dennis

 

[Dennis]

thanks for the tip on the xlam file extension. i found a file called
html.xlam in the office 12\library folder. i'm going to send it to work to
see if it updates that ribbon.

Thanks,
Dennis

 

[Jon Peltier]

That won't do it. Excel doesn't write the code to edit the ribbon, you have
to do that yourself. It's not too hard, but conceptually it takes a while to
sink in. Ron De Bruin has some good help for starting up:

http://www.rondebruin.nl/ribbon.htm

..xlam is the file extension for an Excel add-in. If you customize the ribbon
in an Excel workbook (.xlsm or I guess .xlsx), the interface is customized
only when that workbook is active (unlike in prior versions of Excel). But
if you customize the ribbon and then convert the governing workbook to an
add-in, the customizations are active as long as the add-in is open or
installed.

- Jon

 

[Jim Rech]

the Excel XLB file records your menu and toolbar customizations pre-2007.
The only thing you can customize in Excel 2007 is the QAT. QAT
customizations are recorded in the EXCEL.QAT file found here under Windows
XP:

C:\Documents and Settings\<user name>\Local Settings\Application
Data\Microsoft\OFFICE

 

[iliace]

I create a new Excel document in XLSTART, and save it as add-in named
CustomRibbon.xlam. Then, using this tool:

http://openxmldeveloper.org/articles/CustomUIeditor.aspx

I open the CustomRibbon.xlam and paste this code:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/
customui">
<ribbon>
<tabs>
<tab id="tabMyTab" label="My Tab" insertBeforeMso="TabHome">
<group idMso="GroupDataTools" />
<group idMso="GroupClipboard" />
<group idMso="GroupPageSetup" />
</tab>
</tabs>
</ribbon>
</customUI>

Save the file, exit UI Editor, and restart Excel. A new tab called
"My Tab" will appear before the Home tab, and will receive focus on
load. It will contain Data tools, Clipboard tools, and Page Setup
tools, but you can make them anything you want. You can also program
macros within the add-in file, to respond to user interaction with non-
standard commands.

A complete list of standard controls can be acquired here:

http://www.microsoft.com/downloads/...e9-4d11-46a5-898d-23e4f331e9ae&displaylang=en