Datasheet

17
Chapter 1: Using Macros and Form Controls
8
7
0
9
You can also assign a macro to a custom Ribbon tab. Right-click the Microsoft Office Ribbon. A menu appears.
Click Customize the Ribbon. The Excel Options dialog box appears with the Customize the Ribbon pane selected.
Click the down arrow (
) next to the Choose Commands From field and then select Macros. Click the down arrow
(
) next to the Customize the Ribbon field and then select Main Tabs. Click the New Tab button. Excel creates a
new tab and a new group. Click New Tab (Custom) and then click Rename. The Rename dialog box appears. Type
the name you want to give the tab and then click OK. Click New Group (Custom) and then click Rename. The
Rename dialog box appears. Type the name you want to give the group and then click OK. Click the macro you
want to add to the custom Tab and then click the Add button. Excel places the macro in the Main Tabs box. Click
Rename. The Rename dialog box appears. Click the symbol you want to use to represent the macro. Click OK to
close the Rename dialog box. Click OK to close the Excel Options dialog box. The macro appears on the new tab
you created.
•
The button appears on the Quick Access
toolbar.
0 Click the button to execute your macro.
Excel executes the macro.
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.
03_591598-ch01.indd 1703_591598-ch01.indd 17 6/11/10 1:41 PM6/11/10 1:41 PM