Page 180 - Excel Data Analysis

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

EXCEL DATA ANALYSIS

RUN A MACRO

ou can run a macro to perform a repetitive data When you create a macro, Excel stores it in one of three
analysis task that normally would require multiple steps locations: the current workbook, a new workbook, or the
Y to save yourself some time. You can run macros in a Personal Macro Workbook. Excel opens the Personal Macro
worksheet that exist either in the current workbook or in Workbook as a hidden file each time that you run Excel and
any other Excel workbook, as long as the corresponding makes all the macros that you store there available to run
workbook is open. When you run a macro, Excel re-creates with any workbook. You can learn more about creating a
the recorded steps that you performed to create it or runs the macro in the section "Record a Macro."
VBA code that you created in the Visual Basic Editor. See To run a macro from another workbook, the macro must be
the section "Create a Macro Using the Visual Basic Editor" from a signed source, or you must set your macro security
for more information on the Visual Basic Editor.
to either Medium or Low. The default macro security level,
You select macros to run from the Macro dialog box, which High, requires that all macros from other sources be signed.
lists all currently available macros — those that Excel can Setting your macro security to Medium or Low enables you
locate in an open workbook. Because you can access only to run unsigned macros. See the section "Set Macro
macros in open workbooks, you must open the workbook Security" for more information about macro security.
containing the macro that you want to run first.

RUN A MACRO

Ch09-RunMacro.xls

⁄ Click File ➪ Open. ■ The Open dialog box ‹ Click Open.
opens.
¤ Click the workbook
containing the macro that
you want to run.

166