Fix Disabled VBA Macros and Add-ins in Excel
Question details
The user needs to re-enable a previously working VBA add-in or macro in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to load and use a VBA add-in or macro that previously worked.
- Observed behavior
- Excel no longer allows the add-in or macro to be enabled, although the related options and ribbon settings appear correct.
Confirm that you are using the desktop version of Excel and identify the affected add-in or workbook. Only enable macros or add-ins from a source you trust.
Test the Excel Add-in with Administrator Access
Use this test to determine whether Windows permissions are preventing the add-in from loading.
Save your work and close all Excel windows.
On Windows, right-click the Excel shortcut or Start menu result and select Run as administrator. Approve the prompt if you are authorized to do so.
In Excel, open File > Options > Add-ins. Select the appropriate add-in type in the Manage list, click Go, and try enabling the affected add-in.
If the add-in works only with administrator access, ask your IT administrator to review file permissions, add-in security, and organizational policies for your normal account.

Check Excel Trust Center and Add-in Settings
Review security settings and blocked files if Excel still prevents a trusted VBA project from loading.
Work with Excel Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. It supports common Excel formats for easier migration, but it does not fix Excel security policies or guarantee compatibility with every VBA macro or add-in.

Frequently Asked Questions
Why does the add-in work only when Excel runs as administrator?
The add-in may need access to a file, folder, or setting that your normal account cannot use. Ask your IT administrator to review permissions and organizational policies.
Where can I check whether an Excel add-in is disabled?
Go to File > Options > Add-ins. In the Manage list, select Disabled Items and click Go to see whether the add-in is listed.
Why is a macro blocked after I download a workbook?
Excel may block macros in files marked as coming from the internet. If you trust the source, right-click the file in Windows File Explorer, select Properties, and use Unblock if that option is available.
Can WPS Office fix Excel's disabled VBA add-in?
No. Excel permissions, Trust Center settings, and organizational policies must be addressed in Excel or by your IT administrator. WPS Office can open common Excel spreadsheet formats, but VBA add-in compatibility is not guaranteed.




