About this lesson
How to run a macro from the Macro dialog.
Download this lesson’s exercise file.Running Macros: Using the Macro dialog.xlsm
Running Macros: Using the Macro dialog
Running Macros via the Macros dialog
When to use
When you want to see what macros exist in the file, or run a macro
Open the Macros dialog via either of the following methods:
- Click on the Macros icon in the Developer tab
- Press Alt + F8
Make sure the macro you want to run is selected and click Run.
Hints & tips
- If you open a file containing a macro from an un-trusted source, a prompt will appear under the ribbon warning you that the file contains a macro, and asking if you would like to enable the macro. If you say no, you will not be able to run your macros.
- If you open a file from a trusted source, then you will not receive this prompt
Lesson notes are only available for subscribers.