Page 179 - Excel Data Analysis

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

AUTOMATING ACTIONS WITH MACROS 9

You can use the Store Macro In option to store your
macros in the current workbook, a new workbook, or the
Personal Macro Workbook. You can store the macro in
your current workbook, commonly referred to as the
active workbook, by selecting the This Workbook option.
Use this option if you want the macro available to anyone
who opens the workbook. You can record the macro to a
new workbook by choosing the New Workbook option.
Excel creates the workbook automatically and adds the
new macro to it. If you store a macro in another
workbook, you need to open that workbook whenever
you want to use that macro. You store macros in separate
workbooks when you want to store specific types of
macros in different workbooks. You can record a global
macro by selecting Personal Macro Workbook, which
serves as a common storage location for macros that you
expect to use with other workbooks. Excel stores your
Personal Macro Workbook as Personal.xls in the
XlStart folder. This workbook does not exist until you
store a macro in it. After you create the workbook, it
loads as a hidden workbook whenever you run Excel.

■ The Stop Recording Á Perform the appropriate ■ Excel records the macro. ■ The Stop Recording
toolbar appears. keystrokes to record the toolbar no longer displays
macro. on the screen.
■ The status bar reminds you
that a macro is recording. ‡ When complete, click the
Stop Recording button.

165