Datasheet

Chapter 1: Using Macros and Form Controls
15
If you do not use a macro shortcut frequently, it is
easy to forget the keyboard shortcut you assigned
to your macro. If you forget your keyboard shortcut,
you can view it in the Macro Options dialog box.
You can execute a macro by assigning the macro to a
picture, clip art, shape, or SmartArt. For example, if
you want to assign a macro to a picture, you start by
inserting the picture into your worksheet by clicking
the Insert tab and then clicking Picture. The Insert
Picture dialog box appears. In the Look In field,
select the folder in which you stored the picture you
want to insert. The pictures in that folder appear.
Click the picture you want to insert and then click
the Insert button. The picture appears in the
worksheet. Click and drag the picture to place it
where you want it and then double right-click the
picture. A menu appears. Click Assign Macro. The
Assign Macro dialog box appears. Click the macro
you want to assign to the picture and then click OK.
Excel assigns the macro to the picture. Click the
picture when you want to execute the macro.
1
LAUNCH WITH A KEYBOARD SHORTCUT
1 Select the cells in which you want the macro
to execute.
2 Press Ctrl and the shortcut key.
The macro executes.
3 Repeat steps 1 and 2 to execute the macro
again.
04_132302 ch01.qxp 7/27/07 9:20 PM Page 15