How to Fix Excel VBA Editor Crashes After Office Repair
Question details
The Excel Visual Basic Editor continuously crashes even in Safe Mode or when opening a blank workbook with macros disabled.
- Product
- Microsoft Excel (Microsoft 365)
- Device & OS
- Windows 10 Pro
- Scenario
- Attempting to open or use the VBA Editor in Excel after performing an Office repair or reinstallation.
- Observed behavior
- The VBA Editor crashes immediately, indicating a software or core installation issue rather than a conflict with Personal.xlsb or user macros.
Ensure you have saved all your open workbooks and have your Microsoft 365 account login credentials ready before performing a complete uninstallation.
Use the Microsoft Office Uninstall Support Tool
Since standard repairs and Safe Mode do not resolve the issue, a clean removal of all Office files using the official support tool is required.
Standard uninstallation via the Windows Control Panel often leaves behind corrupted registry keys or cache files. The official Microsoft uninstall tool completely removes these remnants.
Download the Microsoft Office Uninstall Support Tool from the official Microsoft Support website.
Launch the tool and select your version of Microsoft 365 or Office from the provided list.
Follow the on-screen prompts to completely remove all Office files, cache directories, and registry keys from your system.
Restart your Windows computer once the uninstallation is completely finished to clear any locked files.
Log in to your Microsoft account online and perform a fresh installation of Microsoft 365.
Contact Microsoft Technical Support
If the clean installation fails, the issue may be tied to a deeper OS conflict requiring Microsoft Support.
Use WPS Office to Open and Edit Your Spreadsheets Seamlessly
If Microsoft Excel's VBA editor keeps crashing and disrupting your workflow, consider switching to WPS Office. It is a free, lightweight, and highly compatible alternative that supports standard Excel formats without the heavy system overhead.
- 1. Download WPS Office: Visit the official WPS website to download the free installation package.
- 2. Install the software: Run the installer and follow the quick setup wizard to install WPS Office on your computer.
- 3. Open your spreadsheets: Right-click your existing Excel files, select 'Open with', and choose WPS Spreadsheets to continue working without interruptions.
Frequently Asked Questions
Why does the VBA Editor crash even in Safe Mode?
If the VBA Editor crashes in Safe Mode, it indicates the issue is not caused by third-party add-ins or the Personal.xlsb startup file. It is usually related to corrupted core Office installation files, registry keys, or Windows OS conflicts.
Will uninstalling Office delete my Excel files?
No, using the Microsoft Office uninstall support tool only removes the application files and registry settings. Your personal Excel workbooks (.xlsx, .xlsm) saved on your local drive or OneDrive will remain intact.
How do I know if the Personal.xlsb file is causing the issue?
You can test this by navigating to the Excel XLSTART folder and temporarily moving the Personal.xlsb file to your desktop. If the VBA editor still crashes upon opening a blank workbook, the Personal.xlsb file is not the cause.
