VBA & Macro Problems

Fix Excel VBA Buttons Not Working After Excel 2024 Migration

Amos Gikunda Sep 27, 2026 869 views

Question details

Users migrating to a newer Excel version find that their VBA buttons stop running assigned procedures, although the macros still execute properly from the VBA editor.

Fix Excel VBA Buttons Not Working After Migrating to Excel 2024

Product: Microsoft Excel 2024
Device & OS: not provided
Scenario: Migrating workbooks containing macros and ActiveX controls from Excel 2019 to Excel 2024.
Observed behavior: VBA buttons become unresponsive and Developer-mode actions fail to trigger their assigned procedures, often caused by disabled ActiveX controls in the new version's security settings.

Before you start

Before adjusting your security settings, ensure that your workbook is saved as a Macro-Enabled Workbook (.xlsm) and that you trust the source and author of the file.

Solution 1Recommended

Enable ActiveX Controls in Excel Trust Center

The most common cause of unresponsive VBA buttons after an update is stricter default security settings for ActiveX controls. Enabling them restores the interface functionality.

Microsoft periodically tightens security protocols in newer Excel versions to prevent malicious code execution. If your buttons rely on ActiveX controls, these restrictions will prevent the user interface from triggering the underlying VBA script.

Open Excel Options

Launch Excel 2024, click on the 'File' tab in the top-left corner, and select 'Options' at the bottom of the left-hand menu.

Navigate to Trust Center Settings

In the Excel Options dialog, select 'Trust Center' from the left pane, then click the 'Trust Center Settings' button on the right.

Adjust ActiveX Settings

Click on 'ActiveX Settings' in the left menu. Select the option that enables all controls or prompts you before enabling them, depending on your security preference.

Disable Safe Mode for ActiveX

Ensure that the 'Safe mode' checkbox is unchecked if your specific controls require it, then click 'OK' to save your changes.

Restart and Test

Close Microsoft Excel entirely and reopen your workbook. Click the VBA button to verify that the assigned procedure now runs correctly.

Enable ActiveX Controls in Excel Trust Center

Security Reminder: Only enable ActiveX controls for workbooks obtained from trusted sources, as they can be used to run potentially harmful code.

Solution 2

Verify Macro Security and Trusted Locations

If ActiveX settings are correct but buttons still fail, Excel might be blocking the macros entirely based on file location or macro security policies.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

Tired of troubleshooting macro, ActiveX, and security settings after every update? WPS Office provides a lightweight, highly compatible alternative to Microsoft Office. With a familiar interface and excellent format compatibility, migrating your daily spreadsheet tasks is seamless and straightforward.

1. Download the Software: Visit the official WPS website to download and install WPS Office Free on your computer.
2. Open Your Spreadsheet: Launch WPS Spreadsheets, click 'File' > 'Open', and select your existing Excel workbook.
3. Work Seamlessly: Continue editing, formatting, and analyzing your data using a familiar toolset without compatibility issues.

Fully compatible with Microsoft Excel formats (.xlsx, .xlsm, .csv).Lightweight design ensures fast file loading and smooth performance without heavy background updates.Familiar user interface with zero learning curve for existing Excel users.Avoids complex legacy ActiveX conflicts while supporting advanced data analysis tools.

Frequently Asked Questions

Why do my VBA macros work in the editor but not when clicking the button?

This happens when the macro code itself is intact, but the button interface (often an ActiveX control) is blocked by Excel's Trust Center settings. The button fails to send the command to execute the code.

Does saving the file in a different format fix broken VBA buttons?

No, if the file is already a Macro-Enabled Workbook (.xlsm), the issue is typically related to Excel's application-level security settings rather than the file format.

Where can I get help if my VBA macros are completely broken after migrating?

For complex script issues that aren't fixed by security settings, you can post a reproducible example of your code on programming forums like Stack Overflow using the 'VBA' tag to get help from developers.

Excel & Data Problems