[spacesurfer]

My pleasure.

It does seem, however, that not many people are interested in changing their default ribbon ui. i, for one, couldn't stand the default ribbon ui. i had to have it the way i want it.

i'm glad the this method works with office 2010 as well!

[tgsa]

Hey, thanks for the great guide. I'm somewhat new to modifying this and need some help. What I'd like to do is create a new tab (which I can do) and use some buttons for specific symbols (such as the summation symbol or tickmarks). I know how to get the buttons on, but how do I get it to link a button to insert a specific symbol? Is it possible to do this just using xml code or do I have to use macros? I'd like to set this up on multiple computers to work with all spreadsheets, but I know word or excel don't have macros enabled automatically and if I can avoid using macros I'd prefer that.

Thanks again!

[spacesurfer]

You can't do with just the xml. The xml only points to VBA code (i.e. macros) or visual c++. xml does not and cannot run commands on its own.

You will have to use macros. Just record the macro for what you're trying to do. Save the final file as .dotm for the macro-enabled template. It doesn't matter what you're macro settings are. As long as normal.dotm is macro-enabled, you shouldn't have problems.

[ScottJ]

For office 2007. The ribbon xml file header is
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">

Bug for office 2010, the following header is better
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" onLoad="OnLoad">

http://www.ucmapi.com