VBA & Macro Problems

Fix Excel 365 Macros Missing from the View Macros Menu

Maira MehtabMaira Mehtab Nov 13, 2026 869 views

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.

Fix Excel 365 Macros Missing from the View Macros Menu
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.
Before you start

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.

Solution 1Recommended

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.

1
Close and reopen Excel

Save your work, close Excel 365 completely, and reopen the workbook that should contain the macros.

2
Confirm the macro-enabled file type

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.

3
Open the View Macros dialog again

Go to View > Macros > View Macros and check whether the macro names now appear.

Check the Workbook Format and Restart Excel
Macros visible: If the macro list appears, the problem was the workbook format or a temporary Excel session issue.
Free Microsoft Office alternative

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. 1. Download WPS Office: Download and install WPS Office from the official WPS website, then launch WPS Spreadsheets.
  2. 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. 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.
Opens macro-enabled .xlsm and .xlsb workbooks so you can continue working with spreadsheet content outside Excel 365.Maintains compatibility with Microsoft Excel .xlsx, .xls, .xlsm, and .xlsb formats for easy file sharing.Free, lightweight Office suite with a familiar ribbon-style interface, reducing the need for retraining.Includes WPS Spreadsheets for everyday spreadsheet tasks, with macro and VBA features to support existing workflows.
microsoft office alternative - wps office

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.