VBA & Macro Problems

Fix Disabled VBA Macros and Add-ins in Excel

Anum MushtaqAnum Mushtaq Nov 22, 2026 868 views

Question details

The user needs to re-enable a previously working VBA add-in or macro in Excel.

Fix Disabled VBA Macros and Add-ins 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.
Before you start

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.

Solution 1Recommended

Test the Excel Add-in with Administrator Access

Use this test to determine whether Windows permissions are preventing the add-in from loading.

1
Close Excel

Save your work and close all Excel windows.

2
Run Excel as administrator

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.

3
Try the add-in again

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.

4
Review the result

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.

Test the Excel Add-in with Administrator Access
Use administrator access as a test: Running Excel as administrator does not identify or resolve the underlying permissions issue. Do not use it as a permanent workaround without reviewing the cause.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for everyday workMove existing spreadsheet files into a lightweight Office alternativeWork with spreadsheet data without relying on the affected Excel add-in
microsoft office alternative - wps office

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.