VBA & Macro Problems

Fix Excel VBA Editor Buttons Disappearing After Restart

John WilsonJohn Wilson Nov 4, 2026 870 views

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.

How to Fix Excel VBA Editor Buttons Disappearing After Restart
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 you start

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.

Solution 1Recommended

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.

1
Access Excel Options

Open Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Options' from the bottom of the menu.

2
Manage Excel Add-ins

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'.

3
Manage COM Add-ins

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'.

4
Restart and Verify

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.

Disable Conflicting Excel and COM Add-ins
Identifying the Culprit: If the buttons remain after disabling all add-ins, re-enable them one by one, restarting Excel each time, to identify which specific add-in is causing the toolbar reset.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS website to download and install WPS Office for free.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsm files without losing any macro data.
  3. 3. Access Developer Tools: Navigate to the Developer tab to access the built-in macro editor and customize your workspace effortlessly.
Highly compatible with Microsoft Excel formats, including .xlsx and macro-enabled .xlsm filesLightweight application that opens quickly without heavy background processes overriding your settingsFamiliar user interface for seamless migration without a steep learning curveStable macro environment that preserves your toolbar customizations and developer preferences
microsoft office alternative - wps office

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.