Microsoft Office Tutorials and References
In Depth Information
Saving and resetting your custom Quick Access Toolbar
Modify Button dialog box appears, as shown in Figure 3-17, and you can use it to select a
different image.
For more information about macro-enabled workbooks, see “Saving files” in Chapter 2,
“Exploring Excel fundamentals.” For more information about macros and VBA, see Chapter 28,
“Recording macros.”
Figure 3-17 You can change the default button image for your custom macro-driven buttons.
Saving and resetting your custom Quick Access Toolbar
In the Quick Access Toolbar category of the Excel Options dialog box, the default setting in
the Customize The Quick Access Toolbar drop-down list is For All Documents. In this case,
Excel saves the configuration of the Quick Access Toolbar when you exit the program. If
you want to go back to the way things were, click the Reset menu and select Reset Only
The Quick Access Toolbar or Reset All Customizations (which resets both the ribbon and the
Quick Access Toolbar).
If you want to save your custom toolbar so that you can use it again later, there are two
ways to do it. The Import/Export button allows you to save or retrieve a special file
containing all your customizations (both toolbar and ribbon). Figure 3-9 earlier in this chapter
shows a version of the File Open dialog box that appears when you click Import
Customization File from the Import/Export menu, displaying files with the extension .exportedUI .
The second way to save a custom toolbar is to attach it to a workbook. To do so, right-click
any button or tab, and click Customize Quick Access Toolbar. In the Excel Options dialog
box, click the Customize Quick Access Toolbar drop-down list, as shown in Figure 3-18.
Search JabSto ::

Custom Search