Fix Excel VBA Editor Buttons Disappearing After Restart
Question details
The user needs to permanently restore the Comment Block and Uncomment Block buttons in the Excel VBA Editor, as they keep disappearing every time the application is closed and reopened.

- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Customizing the VBA Editor toolbar to include the Comment Block and Uncomment Block buttons for efficient macro editing.
- Observed behavior
- The added Comment Block and Uncomment Block buttons fail to save to the toolbar layout. They disappear from the VBA Editor whenever Excel is restarted, and the issue persists across all files and in Safe Mode.
Before troubleshooting, ensure you have administrative privileges on your computer to manage COM Add-ins, and verify whether your Office installation is centrally managed by an IT department.
Disable Conflicting Excel and COM Add-ins
Third-party add-ins can interfere with saving UI preferences in the VBA Editor. Disabling them helps identify if an extension is causing the buttons to reset.
Even when Excel is launched in Safe Mode, certain persistent COM add-ins or background services may still affect the VBA environment. Isolating and disabling these add-ins is the most effective way to prevent toolbar resets.
Open Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Options' from the bottom of the menu.
In the Excel Options window, click on 'Add-ins' on the left sidebar. At the bottom of the window, ensure the 'Manage' dropdown is set to 'Excel Add-ins', and click 'Go'. Uncheck all add-ins in the list and click 'OK'.
Return to File > Options > Add-ins. Change the 'Manage' dropdown to 'COM Add-ins' and click 'Go'. Uncheck all active COM add-ins and click 'OK'.
Close Microsoft Excel entirely. Reopen Excel, launch the VBA Editor (Alt + F11), re-add the Comment Block buttons, and restart Excel once more to see if the buttons are now preserved.

Review Organizational IT Policies
If your Office 365 installation is managed by an organization, IT policies might restrict or automatically reset VBA Editor customizations upon launch.
Experience Stable Macro Editing with WPS Office
If Microsoft Excel continues to reset your VBA Editor preferences due to local conflicts or strict policies, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet editor with robust macro support, ensuring your customizations stay exactly where you leave them.
- 1. Download and Install: Visit the official WPS website to download and install WPS Office for free.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsm files without losing any macro data.
- 3. Access Developer Tools: Navigate to the Developer tab to access the built-in macro editor and customize your workspace effortlessly.

Frequently Asked Questions
Why do VBA Editor toolbars reset after restarting Excel?
This typically happens due to conflicting COM add-ins, corrupted UI preference files (*.exd), or organizational IT policies that enforce default settings and overwrite personal customizations upon application launch.
How do I manually add the Comment Block button in the VBA Editor?
Open the VBA Editor (Alt + F11), right-click the toolbar at the top, select 'Customize', go to the 'Commands' tab, select 'Edit' from the categories, and drag 'Comment Block' or 'Uncomment Block' to your toolbar.
Does Excel Safe Mode fix VBA toolbar issues?
Safe Mode bypasses add-ins and startup files. If the buttons disappear even in Safe Mode, the issue is likely related to restricted user permissions, IT-managed policies, or a deeper installation corruption rather than a simple add-in conflict.




