Page 202 - Excel Data Analysis

10 537547 Ch09.qxd 3/4/03 12:13 PM Page 188

EXCEL DATA ANALYSIS

ASSIGN A MACRO TO A MENU

f you frequently use specific macros to analyze your Workbook is always open, any workbook can use all its
worksheet data, you may want to assign the macros to macros.
I an Excel menu to make them easier to activate. You can To keep your macros easy to find, you may want to place
assign a macro to any existing Excel menu. If you do not them all on one custom menu. For example, you can place
want to use existing menus, you can even create a new all of your data analysis macros on a menu named Data
menu. By assigning a macro to a menu, you make the macro Analysis. You can create a new Excel menu using the
as accessible as any menu option. Assigning macros to Customize dialog box. Of course, whatever menu you
menus eliminates the need to remember the shortcut key decide to use as a home for your macro must exist in the
required to launch the macro.
Excel window before you can add the macro option to it.
When you add a macro to a menu, it remains on the menu You add options to a menu by dragging them onto the
for all workbooks that you open in Excel. For that matter, menu from the Customize dialog box. In fact, you can
you should assign the macros in your Personal Macro modify menus only when the Customize dialog box is
Workbook to a menu for easy access from all workbooks. open. You can remove menu options in a similar fashion
The Personal Macro Workbook stores commonly used by dragging them from the menu back to the Customize
macros for the current user and opens as a hidden file each dialog box.
time that you run Excel. Because the Personal Macro

ASSIGN A MACRO TO A MENU

Macros

⁄ Click Tools ➪ Customize. ■ The Customize dialog box ¤ Click the Commands tab. ˇ Drag the item to the
appears. desired menu.
‹ Click Macros.
■ The menu expands and a
› Click Custom Menu Item.
line indicates your position in
the menu.
Á Release the mouse
button.
188