VBA & Macro Problems

Fix Disabled VBA and Macros in Microsoft Office Without Running as Administrator

Algirdas JasaitisAlgirdas Jasaitis Nov 13, 2026 869 views

Question details

Restore access to VBA and macros in Microsoft Office applications without routinely running them as administrator.

Fix Disabled VBA and Macros in Microsoft Office Without Administrator Rights
Product
Microsoft Office
Device & OS
Windows
Scenario
VBA and macros need to work under a standard Windows user account across multiple Office applications.
Observed behavior
Visual Basic and macros are disabled in multiple Office applications unless they are run as administrator.
Before you start

Confirm whether the computer is personally owned or managed by an organization, and test with a macro-enabled file you trust. Close all Office applications before changing their executable properties or starting a repair.

Solution 1Recommended

Remove Unnecessary Office Compatibility Settings

Use this first to check whether an Office application is configured to use compatibility mode or elevated permissions.

1
Find the executable

Search for the affected Office application in the Windows Start menu, right-click it, and select Open file location. If that opens a shortcut, right-click the shortcut, select Properties, and use Open File Location to find the executable.

2
Check compatibility

Right-click the application executable, select Properties, and open the Compatibility tab. Clear any unnecessary compatibility mode selection and the Run this program as an administrator checkbox, then select Apply and OK.

3
Retest normally

Open the application from the Start menu without choosing Run as administrator. Open a trusted macro-enabled file and check the Developer tab or press Alt+F11 to test access to VBA.

4
Repeat for other applications

Repeat the executable Properties and Compatibility checks for each affected Office application, such as Excel or Word.

Remove Unnecessary Office Compatibility Settings
Settings may require administrator access: Settings applied to all users may require an administrator to change them. Removing compatibility settings will not override a macro security policy.
Free Microsoft Office alternative

Use WPS Office as a Lightweight Office Alternative

WPS Office is a free, lightweight alternative with a familiar interface and support for common Microsoft Office formats, making it easier to move everyday documents and spreadsheets. It does not repair Microsoft Office permissions or policies; check macro support for your WPS version and platform before relying on VBA files.

Open and edit common Microsoft Office formats, including DOCX, XLSX, and PPTXWork with a familiar Office-style interfaceUse a lightweight suite for everyday documents and spreadsheetsEvaluate macro support separately when moving VBA-dependent files
microsoft office alternative - wps office

Frequently Asked Questions

Why do my macros work only when Office runs as administrator?

The difference may be related to compatibility settings, file or folder permissions, account-specific configuration, or security policies. Check the application's executable Properties > Compatibility and review its Trust Center settings.

Where can I check macro settings in Office?

In the affected application, go to File > Options > Trust Center > Trust Center Settings > Macro Settings. Some options may be controlled by your organization's policy.

Should I enable all macros to fix the problem?

No. Enabling all macros can allow malicious code to run. Use files from trusted sources and follow your organization's security policy.

How do I repair Office on Windows?

Close Office, then go to Settings > Apps > Installed apps or Apps & features. Select Microsoft Office or Microsoft 365, choose Modify, and run Quick Repair. Try Online Repair if needed.

Can WPS Office fix Microsoft Office macro policies?

No. Microsoft Office policies and permissions must be addressed in Office or Windows. WPS Office is an alternative for everyday files, but VBA support depends on the WPS version and platform.