Microsoft Office Tutorials and References
In Depth Information
Questions About Ribbon Customization
33. Browse to a folder and provide a name for the customization file. The
file type will be .exportedUI. Click OK.
44. In Windows Explorer, find the exported .exportedUI file. Copy it to a
co-worker s computer.
55. On the co-worker s computer, repeat step 1. In step 2, select Import
All Customizations. Find the file and click OK.
Questions About Ribbon Customization
Can the customizations apply to only a certain workbook?
Can the customizations apply to only a certain workbook?
No. The Customize the Ribbon command in Excel 2013 applies to all work-
books.
Can
Can toolbars
toolbars bbe docked
docked tto the
the side
side oof the
the screen
screen oor floating
floating aas iin Excel
Excel
97 2003?
97 2003?
No. The ribbon always must be at the top of the screen, in a horizontal
position.
Can I reset my customizations and go back to the original Ribbon?
Can I reset my customizations and go back to the original Ribbon?
Right-click the ribbon and select Customize the Ribbon. Below the right
list box, select Reset, Reset All Customizations.
Where
Where iis the
the Excel
Excel 2003
2003 icon
icon editor?
editor? Where
Where iis the
the list
list oof 4,096
4,096 icons
icons avail-
avail-
able back in Excel 2003?
able back in Excel 2003?
Neither item is supported in Excel 2013.
How can I get complete control over the ribbon?
How can I get complete control over the ribbon?
Learn RibbonX and write some VBA to build your own ribbon.
Formoreinformationonbuildingyourownribbon,see
see RibbonX:
Customizing the Office 2007 Ribbon, byRobertMartin,KenPuls,
and Teresa Hennig (Wiley, ISBN 0470191112).
These
These ribbon
ribbon customizations
customizations are
are really
really lacking.
lacking. IIs there
there another
another option
option
that doesn t require me to write a program?
that doesn t require me to write a program?
Yes, a number of third-party ribbon customization programs are avail-
able. For example, check out a free one from Excel MVP Andy Pope at
www.andypope.info/vba/ribboneditor.htm .
Search JabSto ::




Custom Search