Fix Disabled VBA and Macros in Microsoft Office Without Running as Administrator
Question details
Restore access to VBA and macros in Microsoft Office applications without routinely running them as administrator.

- 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.
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.
Remove Unnecessary Office Compatibility Settings
Use this first to check whether an Office application is configured to use compatibility mode or elevated permissions.
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.
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.
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.
Repeat the executable Properties and Compatibility checks for each affected Office application, such as Excel or Word.

Review Office Macro Security and Windows Permissions
Check whether security settings or account permissions explain why macros behave differently under elevation.
Repair the Microsoft Office Installation
Use Office repair if the issue persists on a personal computer after checking compatibility and security settings.
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.

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.




