Microsoft Office Tutorials and References
In Depth Information
Run a Macro
Chapter 11: Learning VBA Basics
The Macro dialog box
4 Click the Macros In
drop-down arrow and
select the workbook that
contains the macro you
want to run.
If you are not sure which
workbook contains the
macro, select All Open
Excel displays a list of
macros in the workbook.
5 Click the macro you want
6 Click Run.
If you assigned a shortcut
key to the macro, you
can avoid steps 2 to 6 by
pressing the shortcut key.
Excel runs the macro.
The default macro security settings in Excel
may prevent you from running any macros
stored outside the Personal Macro Workbook.
If you cannot perform the steps in this
section — particularly after you create one or
more macros and then close and restart
Excel — then you either need to lower the
macro security settings in Excel or “self-sign”
your own macros. See Chapter 10 to learn
how to digitally sign your own macros.
You can also use the Macro dialog box
as an easy method for displaying a
macro in the VBA Editor. Follow steps
1 to 3 to open the Macro dialog box
and select the macro you want to
work with. Click the Edit button. Excel
launches the VBA Editor, opens the
module that contains the macro, and
then displays the macro code.