Microsoft Office Tutorials and References
In Depth Information
Saving and Reusing Custom Ribbon and Toolbar Settings
Saving and Reusing Custom Ribbon and Toolbar Settings
The right customizations can have a positive effect on your productivity and on your
aching muscles. Arranging commonly used commands in a convenient location can help you
eliminate unnecessary mouse movements and clicks. If you invest more than a few minutes
customizing a layout, save your settings in a backup location. Later, you can use that
settings file to restore your custom ribbon and Quick Access Toolbar arrangements on a new
PC or after reinstalling Office. You can also share the saved settings with other people and,
as we explain in the Inside Out sidebar at the end of this section, you can modify the saved
settings to quickly share some customizations between Office programs.
You’ll find the Import/Export button at the bottom of the customization dialog boxes for
the ribbon and the Quick Access Toolbar. The available options and results are the same in
either place.
INSIDE OUT Move your settings from Word to Excel? Yes, but . . .
The export option saves your custom settings as an XML file. The import option uses
that file to restore settings. Given the similarities between Office programs, you might
be tempted to try exporting settings from one Office program and importing them in
another. Surprisingly, it works—if you follow some common-sense guidelines and keep
your expectations reasonable.
You’ll be most effective if you stick with commands that are shared among Office
programs. That’s actually pretty easy: the custom tab shown in Figure 3-12 was created
in Word but works reasonably well in Excel, with three commands in the Insert group
missing after the import step is complete.
The secret is to open the saved .exportedUI file in a text editor such as Notepad and
edit a property in the first line of the file. The program you used to export the settings
is identified in a custom tag at the top of the XML file. To import the file to a different
program, you need to change that tag to reflect the target. So, look for this tag:
<mso:cmd app="Word" dt="0" />
Replace “Word” with “Excel.” Save the settings file, being sure to preserve the
.exportedUI extension, and import it into Excel. You now have a good base for
beginning your customization of each program’s unique features.
Search JabSto ::




Custom Search