Excel Macro Shortcut: Open the Macro Dialog Quickly

VBA & macros · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, press Alt+F8 to open the Macro dialog, where you can find, run, or edit available macros. On a Mac, press Option+F8. Opening this dialog does not run a macro; you choose whether to run one after it appears. Use macros only in files and from people you trust.

What You’ll Need

  • The desktop version of Excel. Excel for the web does not run VBA macros or provide the same Macro dialog.
  • A workbook open in Excel if you want to see its macros. If the macro is stored in another workbook, that workbook generally needs to be open too.
  • A keyboard with the relevant keys. On some laptops, you may need to hold Fn as well as the shortcut keys, depending on how the function keys are configured.
  • A macro-enabled workbook or another macro-capable Excel file if you expect a workbook to contain VBA. Common formats include .xlsm, .xlsb, and .xls.

Step-by-Step

  1. Open the workbook in desktop Excel. Launch the file in the installed Excel app rather than Excel for the web. If you opened it from a browser or a shared link, choose the option to open it in the desktop app. The web version can display workbook contents, but it cannot run VBA macros.
  2. Make sure the relevant workbook is open. The Macro dialog can show macros from the current workbook, other open workbooks, or the Personal Macro Workbook, depending on the dialog’s Macros in setting. If you are looking for a macro stored in a separate file, open that file first. You do not need to select a cell or worksheet before using the shortcut.
  3. Press Alt+F8 on Windows. Hold down Alt, tap F8, and release the keys. The Macro dialog should appear. On some laptops the F8 key also controls a hardware feature, such as screen brightness; if the shortcut does not work, try Alt+Fn+F8. You can also check the keyboard’s function-key mode.
  4. Use the Mac shortcut when working in Excel for Mac. Press Option+F8 to open the Macro dialog. If the Mac is set to use the function keys for hardware controls, try Fn+Option+F8. Keyboard settings can vary by Mac, so use the menus below if the key combination is intercepted or has no effect.
  5. Check the macro list and its scope. Look at the Macro name list and the Macros in menu. If the list is empty or a macro is missing, change the scope to the current workbook or all open workbooks, where available. The macro must be in an open workbook and be visible to Excel as a runnable macro. A macro saved only in a closed workbook will not appear just because you open the dialog.
  6. Choose what you want to do. Select a macro name to make the available actions clear. Choose Run only if you trust the file and understand what the macro is intended to change. Choose Edit to inspect its VBA code, if that option is available. Use Cancel or close the dialog to leave without running anything.
  7. Open the dialog from the ribbon if needed. In Windows desktop Excel, use Developer > Code > Macros. If the Developer tab is not visible, another route is View > Macros > View Macros. In Excel for Mac, use Tools > Macro > Macros if that menu is available in your version; the View or Developer ribbon may also provide a Macros command. These routes open the macro list without requiring the keyboard shortcut.
  8. Save a backup before running a macro that changes data. A macro can alter cells, delete sheets, or make other changes, and Excel cannot undo macro actions with Ctrl+Z on Windows or Command+Z on Mac. Save a copy of the workbook before running an unfamiliar or consequential macro. Opening the dialog alone does not change workbook data.

Common Mistakes

Confusing the Macro dialog with the VBA editor: Alt+F8 opens the Macro dialog, not the code editor. On Windows, Alt+F11 opens the Visual Basic for Applications editor. The Mac editor shortcut differs by keyboard and Excel setup, so use the menu command to reach the editor if needed. The dialog is the right place to select and run a listed macro; the editor is where VBA code is viewed or changed.

Expecting an .xlsx file to hold VBA: The .xlsx format does not preserve a VBA macro project. Macro-enabled workbooks commonly use .xlsm, while .xlsb and older .xls files can also contain macros. A workbook may have been saved in a format that removed its macros, so check the file type and ask for the original macro-enabled file if necessary.

Assuming the shortcut runs the selected macro: Alt+F8 only opens the dialog. A macro runs only after you select it and choose Run. Conversely, if you press Run on a macro, it may make changes immediately. Read the macro’s purpose and confirm that the workbook is backed up before proceeding.

Enabling every blocked macro: A security warning is not a prompt to trust an unknown file. Macros can perform actions beyond editing visible cells. Do not lower Excel’s macro security settings or enable content just to make a mystery workbook work. Verify the source and purpose first.

Tips

If you use the dialog often, learn both ways to open it: Alt+F8 and the ribbon route Developer > Code > Macros. The ribbon is useful when a keyboard utility, laptop function-key setting, remote desktop, or another application intercepts the shortcut. It also gives you a visible route to the same macro list.

Use the Macros in menu deliberately. A macro can be stored in the active workbook, another open workbook, or the Personal Macro Workbook, which is normally loaded in the background for your Excel account. If you select only the active workbook, a macro stored in Personal may be hidden from the list. Changing the scope helps identify where Excel is looking; it does not make macros in closed files available.

If your goal is to inspect code rather than run it, select the macro and choose Edit when available. You can also open the VBA editor with Alt+F11 on Windows, then look through the project list for the workbook’s modules. Do not edit code unless you understand the effect of the change. Save a separate copy before experimenting, and close the editor without saving if you have not made changes you want to keep.

For recurring work, consider whether a macro is necessary before adding one. Excel’s built-in commands, formulas, and automation options may be easier to maintain for a simple task. If you do use VBA, keep a clear description of what the macro changes and store the workbook in a suitable macro-capable format. A clear name makes it easier to identify the right item in the Macro dialog.

Troubleshooting

Nothing happens after Alt+F8: Confirm that Excel, not another application, has focus. Try the Fn key combination on a laptop, or open the dialog from the Developer or View ribbon. If using a remote desktop, make sure the key combination is being sent to the computer running Excel rather than handled by your local device.

The Macro dialog opens, but the list is empty: Check the Macros in menu and select the relevant workbook or all open workbooks. Confirm that the file containing the macro is open and that it is not an .xlsx copy with its VBA project removed. Some procedures are not shown as runnable macros—for example, code that is private, requires arguments, or is not a suitable public procedure in a standard VBA module. If you expected a macro supplied with a file, ask its creator whether it was included and where it is stored.

A security message appears or Run is unavailable: Excel may have blocked macros because of the file’s source or security settings. First confirm that the file came from a trusted person or organization and that you have a legitimate reason to run it. Follow your organization’s security guidance; do not bypass a warning for an unknown attachment. If the file is trusted but still blocked, ask the sender or your IT administrator for the approved way to use it.

The workbook opens in Excel for the web: The web app cannot run VBA macros. Open the file in desktop Excel on Windows or Mac to use the Macro dialog. If you do not have desktop Excel, ask the workbook owner for a non-macro version or another approved way to complete the task. Do not assume that viewing the workbook in a browser has run its macros.

You cannot find the Developer tab: In Windows desktop Excel, enable it through File > Options > Customize Ribbon, select Developer in the Main Tabs list, and choose OK. On Mac, open Excel > Preferences or Settings, depending on the version, then look for Ribbon & Toolbar settings and enable Developer. The tab’s visibility is a display setting; enabling it does not enable or run macros.

Frequently Asked Questions

What is the shortcut to open macros in Excel?
In desktop Excel for Windows, press Alt+F8 to open the Macro dialog. On Mac, use Option+F8; try adding Fn if the Mac uses function keys for hardware controls.

Does Alt+F8 run a macro?
No. It opens the Macro dialog. Select a macro and choose Run to execute it. Opening the dialog by itself does not run code or change the workbook.

What is the difference between Alt+F8 and Alt+F11?
Alt+F8 opens the dialog for listing and running macros. Alt+F11 opens the VBA editor on Windows, where you can inspect or edit code. Use the dialog when you only need to choose a macro.

Why is my macro not listed?
Check that the correct workbook is open, then adjust the Macros in scope. The file may be an .xlsx copy without VBA, or the procedure may not be exposed as a runnable macro. Some code, such as a procedure that requires arguments, will not appear as a normal run-ready entry.

Can I open or run macros in Excel for the web?
No. Excel for the web does not support running VBA macros or opening the desktop Macro dialog. Use desktop Excel with the appropriate workbook format, or ask for a non-macro alternative if desktop Excel is unavailable.

Related

Try it: the Column Letter to Number: aA is 27, XFD is 16,384. Converts both ways.

More in VBA & macros

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.