VBA & Macro Problems

Fix Excel Macros Missing from Alt+F8 Macro Dialog

Tauseeq Magsi Oct 10, 2026 869 views

Question details

The user is unable to see their macros in the Alt+F8 dialog box, even though the macro code is still visible in the Visual Basic Editor.

How to Fix Excel Macros Missing from the Alt+F8 Macro Dialog

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to run a saved macro from the personal macro workbook using the Alt+F8 shortcut.
Observed behavior: Macros stored in the personal macro workbook are missing from the Alt+F8 macro dialog list due to restrictive security settings or a corrupted Personal.xlsb file.

Before you start

Before proceeding, open the Visual Basic Editor (Alt+F11) and copy any existing macro code from your Personal.xlsb file to a safe text document to prevent data loss.

Solution 1Recommended

Adjust Excel Trust Center Macro Settings

Check and modify the macro security settings in the Trust Center to ensure macros are not being blocked by Excel.

Excel's default security settings may block macros from running, which can cause them to disappear from the Alt+F8 dialog. Adjusting the Trust Center settings can quickly resolve this.

Open Excel Options

Launch Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Options' at the bottom of the menu.

Navigate to Trust Center

In the Excel Options window, select 'Trust Center' from the left-hand pane, then click the 'Trust Center Settings' button.

Enable VBA Macros

Select 'Macro Settings' from the left menu. Choose the appropriate setting to allow VBA macros (such as 'Enable VBA macros' or 'Disable VBA macros with notification'), then click 'OK'.

Restart Excel

Close Microsoft Excel completely and reopen it to apply the new macro security settings. Press Alt+F8 to check if your macros have reappeared.

Adjust Excel Trust Center Macro Settings

Solution 2

Recreate a Corrupted Personal Macro Workbook

If adjusting security settings fails, your Personal.xlsb file may be corrupted. Deleting and recreating it can restore your macros.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you are experiencing persistent issues with Microsoft Excel macros, security blocks, and workbook corruption, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for viewing, editing, and managing your spreadsheets effortlessly.

1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
2. Install the Application: Run the installer and follow the quick on-screen instructions to set up WPS Office on your device.
3. Open Your Spreadsheets: Launch WPS Spreadsheet and seamlessly open your existing Excel workbooks to continue your work without interruption.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and macro-enabled .xlsm files.Familiar user interface that requires zero learning curve for existing Excel users.Lightweight application that loads significantly faster and consumes fewer system resources.Free to use for everyday spreadsheet, document, and presentation needs.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my macros show in the VBA Editor but not in the Alt+F8 macro list?

This commonly occurs if the macro is declared as 'Private' instead of 'Public', if the macro requires specific parameters to run, or if Excel's Trust Center security settings are actively blocking the macros from executing.

Where is the Personal.xlsb file located on my computer?

The Personal.xlsb file is usually stored in the Excel startup folder (XLSTART), which is typically located at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART on Windows.

How do I back up my macro code before troubleshooting?

Press Alt+F11 in Excel to open the Visual Basic Editor. Locate 'VBAProject (PERSONAL.XLSB)' in the Project Explorer pane, open its modules, and copy the text code into a standard Notepad document.

Excel & Data Problems