Fix Excel 365 Macros Missing from the View Macros Menu
Question details
The user needs to identify why Excel 365 macro names are not listed in the View Macros menu and restore access to the expected macros.

- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- The user opened a macro-enabled workbook in Excel 365, went to View > Macros, and expected to see the available macro names.
- Observed behavior
- The View Macros menu does not display the expected macro names, so the user cannot run or edit the macros.
Save and close any other Excel workbooks before changing settings, and confirm that the workbook you are troubleshooting is saved in a macro-enabled format such as .xlsm or .xlsb. Make sure you can open File > Options so you can verify Trust Center settings and add-ins.
Check the Workbook Format and Restart Excel
Use this first when macros are missing because the workbook may be saved as .xlsx or Excel may be in a temporary error state.
Excel permanently removes macro code when a file is saved as the standard .xlsx workbook. If the file is not macro-enabled, the View Macros dialog has no macros to list, and restarting Excel clears temporary display issues.
Save your work, close Excel 365 completely, and reopen the workbook that should contain the macros.
Select File > Save As and check that the file type is Excel Macro-Enabled Workbook (.xlsm) or Excel Binary Workbook (.xlsb). If it is .xlsx, save a copy as .xlsm or .xlsb.
Go to View > Macros > View Macros and check whether the macro names now appear.

Verify Macro Settings in the Excel Trust Center
Use this when the workbook is macro-enabled but Excel is blocking macros before they can appear or run.
Disable Add-ins and Repair Microsoft Office If Needed
Use this when macro names are still missing after workbook and security checks, because an add-in or damaged Office installation may interfere with the macro dialog.
Switch to WPS Office to Keep Working with Macro-Enabled Spreadsheets
If Excel 365 continues to hide macros from the View Macros menu or the repair options do not help, WPS Office is a free, lightweight alternative that opens macro-enabled workbooks with familiar menus and excellent Microsoft Excel format compatibility.
- 1. Download WPS Office: Download and install WPS Office from the official WPS website, then launch WPS Spreadsheets.
- 2. Open the macro-enabled workbook: In WPS Spreadsheets, choose Open from the file menu, browse to the .xlsm or .xlsb file, and open it.
- 3. Continue editing and save in a compatible format: Review the workbook and macros in WPS Spreadsheets, and save a copy in .xlsm or another Microsoft Excel-compatible format if needed.

Frequently Asked Questions
Why are my Excel 365 macros not visible after I saved the workbook as .xlsx?
A standard .xlsx workbook cannot store macros. Open File > Save As and save the file as an Excel Macro-Enabled Workbook (.xlsm) or Excel Binary Workbook (.xlsb), then reopen it and check View > Macros again.
How do I change macro security settings in Excel 365?
Go to File > Options > Trust Center > Trust Center Settings > Macro Settings. Choose Disable VBA macros with notification or Enable VBA macros, click OK, and reopen the workbook so the macro list can refresh.
Can an Excel add-in make macro names disappear from the View Macros menu?
Yes. An add-in can interfere with Excel's macro dialog. Disable suspected add-ins by going to File > Options > Add-ins, selecting Excel Add-ins or COM Add-ins, clicking Go, and clearing the suspect add-ins before restarting Excel.
What should I do if the macros are still missing after checking the file type and macro settings?
Restart Excel and open the workbook using Open and Repair: File > Open, select the workbook, click the arrow next to Open, and choose Open and Repair. If the problem continues, run a Microsoft 365 Quick Repair or Online Repair from Windows Settings > Apps.
Can WPS Office open Excel macro-enabled workbooks?
WPS Office can open .xlsm and .xlsb macro-enabled workbooks and can work with spreadsheet content. Some advanced VBA features may behave differently, so test important macros after opening the file in WPS Spreadsheets.




