Datasheet

Chapter 1: Using Macros and Form Controls
17
You can add commands you frequently use to the
Quick Access toolbar. Click the Microsoft Office
button. A menu appears. Click the Excel Options
button located in the bottom-right corner. The Excel
Options dialog box appears. Click Customize.
The Customize the Quick Access Toolbar page
appears. Click the down arrow next to the Choose
Commands From field and select All Commands.
Click the command you want to add to the Quick
Access toolbar and then click the Add button. Click
OK. Excel returns you to your workbook, and the
command you chose appears on the Quick Access
toolbar.
You can add commands you cannot find in the
Ribbon by choosing Commands Not in Ribbon in
the Choose Commands From field. If a command
from a previous version of Excel is not in the
Ribbon, you may find it listed under Commands
Not in the Ribbon. For example, in previous versions
you could format your documents quickly by using
AutoFormat. Excel 2007 uses styles, but you can
still access AutoFormat through the Commands Not
in Ribbon feature.
7
8
9
0
The Modify Button dialog box appears.
7 Click the button you want to use to represent
your macro.
8 Click OK to close the Modify Button dialog box.
9 Click OK to close the Excel Options dialog box.
•
Click to return the Quick Access toolbar to its
default state.
•
Click the macro and then click the Remove
button to remove a macro.
The button appears on the Quick Access toolbar.
0 Click the button to execute your macro.
04_132302 ch01.qxp 7/27/07 9:20 PM Page 17