Fix Excel Crashing When You Press Alt+F8 to View Macros
Question details
Find out why Excel crashes when the Macros dialog is opened and restore access to it.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user presses Alt+F8 or selects View Macros to open the Macros dialog.
- Observed behavior
- Excel may close and restart, although macros remain accessible through the Visual Basic Editor.
The troubleshooting steps below apply to Excel on Windows. Note which add-ins are active so you can restore their settings after testing.
Test Excel in Safe Mode and disable add-ins
Use this method to check whether an add-in is causing the Macros dialog to crash.
Press Windows+R, enter excel /safe, and select OK. Open the affected workbook and press Alt+F8.
If Alt+F8 works in Safe Mode, close Excel and reopen it normally. Go to File > Options > Add-ins, select COM Add-ins in the Manage list, and click Go.
Clear the checkbox for one active add-in and click OK. Restart Excel and press Alt+F8. Repeat for each active COM add-in until you identify the cause.
If COM add-ins are not responsible, return to File > Options > Add-ins, select Excel Add-ins in the Manage list, and click Go. Disable active add-ins one at a time, restarting Excel and testing Alt+F8 after each change.

Check and temporarily remove Excel startup files
Use this method if the crash may be caused by a workbook or add-in loaded when Excel starts.
Repair Microsoft Office if Safe Mode also crashes
Try an Office repair if Excel still crashes when you open the Macros dialog in Safe Mode.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and support for common Excel formats, making it easier to move existing spreadsheets. It does not repair Microsoft Excel or its add-ins.

Frequently Asked Questions
Why does Alt+F8 work in Safe Mode but crash Excel normally?
Safe Mode bypasses certain add-ins and startup items. If Alt+F8 works there, test active add-ins under File > Options > Add-ins and check Excel's startup folders.
How do I find Excel's startup folder?
Press Alt+F11, then Ctrl+G. Enter ?Application.StartupPath in the Immediate window and press Enter. Open the displayed path in File Explorer.
What if my COM add-ins are already inactive?
Check Excel Add-ins through File > Options > Add-ins > Manage > Excel Add-ins > Go, and review files in Excel's startup folders. Test one change at a time.
Can I still access macros if the Macros dialog crashes?
You may still be able to view macro code in the Visual Basic Editor by pressing Alt+F11, even if Alt+F8 crashes Excel. This does not resolve the underlying dialog problem.
What should I do if Excel crashes in Safe Mode too?
Try repairing your Microsoft Office installation through Windows Settings > Apps > Installed apps > Microsoft Office or Microsoft 365 > Modify. Start with Quick Repair.




