Shortcut Keys

You can change the shortcut key assigned to a macro using the Macro dialog box shown in Figure 1-3. Select the macro name and click Options. This opens the dialog box shown in Figure 1-4.

Macro Options


Macro name:

Month Names 1

Shortcut (gey;

Ctrl 4- H


Enter Month Names

1 ™

Figure 1-4

It is possible to assign the same shortcut key to more than one macro in the same workbook using this dialog box (although the dialog box that appears when you start the macro recorder will not let you assign a shortcut that is already in use).

It is also quite likely that two different workbooks could contain macros with the same shortcut key assigned. If this happens, which macro runs when you use the shortcut? The macro that comes first alphabetically.

Shortcuts are appropriate for macros that you use frequently, especially if you prefer to keep your hands on the keyboard. It is worth memorizing the shortcuts so you won't forget them if you use them regularly. Shortcuts are not appropriate for macros that are run infrequently or are intended to make life easier for less experienced users of your application. It is better to assign meaningful names to those macros and run them from the Macro dialog box. Alternatively, they can be run from buttons that you add to the worksheet. You learn how to do this shortly.

0 0

Post a comment