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

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.


On Nov 21, 2:07 pm, "Dennis" wrote:
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

Are they part of the personal.xls file then?

Thanks
Dennis


"iliace" wrote in message
...
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.


On Nov 21, 2:07 pm, "Dennis" wrote:
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

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...mUIeditor.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 he

http://www.microsoft.com/downloads/d...displaylang=en


On Nov 21, 5:39 pm, "Dennis" wrote:
Are they part of the personal.xls file then?

Thanks
Dennis

"iliace" wrote in message

...



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.

On Nov 21, 2:07 pm, "Dennis" wrote:
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- Hide quoted text -

- Show quoted text -

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


"iliace" wrote in message
...
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.


On Nov 21, 2:07 pm, "Dennis" wrote:
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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Dennis" wrote in message
...
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


"iliace" wrote in message
...
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.


On Nov 21, 2:07 pm, "Dennis" wrote:
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

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

--
Jim
"Dennis" wrote in message
...
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


"iliace" wrote in message
...
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.


On Nov 21, 2:07 pm, "Dennis" wrote:
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