'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix VBA Buttons Not Working in Excel (Macros Enabled)
Question details
The user's VBA and ActiveX buttons in an XLSM workbook have stopped responding, despite macros being enabled and the file being stored in a trusted location.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Clicking command buttons in a macro-enabled workbook to execute VBA code or automate tasks.
- Observed behavior
- VBA buttons do not respond when clicked. Additionally, the Options window occasionally fails to open, and button dimensions sometimes change unexpectedly.
Ensure you have saved your current workbook and know the exact local path where your .xlsm file is stored before modifying security settings or applying Office updates.
Install the Latest Microsoft Office Updates
Certain Microsoft Office updates contain bugs that break ActiveX controls and VBA buttons. Installing the latest patch often resolves these known issues.
Microsoft occasionally releases security patches that inadvertently disable ActiveX controls or cause VBA buttons to stop functioning. When this happens, Microsoft usually deploys a hotfix in the subsequent update.
Launch Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' from the left sidebar.
Under the 'Product Information' section, click the 'Update Options' drop-down menu and select 'Update Now'.
Wait for Excel to download and apply any available updates, then restart your computer to ensure the changes take effect.
Verify Trust Center and ActiveX Settings
Even if the folder is trusted, restrictive ActiveX settings can prevent specific buttons from running your VBA code.
Repair Microsoft Office
If Excel settings are corrupted, running a built-in repair tool can fix unresponsive buttons, UI glitches, and failing Option windows.
Use WPS Office for a Stable, Macro-Compatible Experience
If Microsoft Excel's VBA buttons keep breaking due to forced Office updates or corrupted software settings, consider switching to WPS Office. It provides robust compatibility with macro-enabled workbooks in a lightweight, free alternative.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open Your Workbook: Launch WPS Spreadsheet and open your .xlsm file containing the VBA buttons.
- 3. Enable Macros: Click 'Enable Macros' in the security warning prompt at the top to allow your buttons to function normally.
Frequently Asked Questions
Why did my ActiveX button change size after I clicked it?
This is a known Microsoft Excel display bug often triggered by screen resolution scaling or corrupted ActiveX caches. Replacing ActiveX controls with standard Form Controls can permanently prevent this resizing issue.
Are Form Controls better than ActiveX controls in Excel?
Form Controls are built directly into Excel and are generally more stable across different versions and updates. ActiveX controls offer advanced formatting but are far more susceptible to security blocks, update bugs, and unresponsiveness.
How do I delete corrupted ActiveX cache (.exd) files?
Press Win + R, type '%temp%', and press Enter. Search the folder for any files ending in '.exd' (such as MSForms.exd) and delete them. Ensure Excel is closed while doing this. Excel will automatically recreate fresh, uncorrupted versions the next time you use ActiveX controls.
