How to Fix "WPS Office Macros Cannot Be Run Because the VBA Support Library Is Not Installed"
If you encounter the error message "WPS Office macros cannot be run because the VBA support library is not installed," it means your current version of WPS Office lacks the necessary Visual Basic for Applications (VBA) environment required to execute automation scripts.
While WPS Office is a popular alternative to Microsoft Office, its Free version typically does not include the VBA support library by default. You must either upgrade to a version that supports it or manually install the missing module. Why is the VBA Support Library Missing?
Version Limitation: The free standard version of WPS Office often excludes the VBA module to keep the installer lightweight or to encourage professional upgrades.
Disabled by Default: In some installations, the VBA support environment might be present but disabled due to security settings or configuration choices.
Incomplete Installation: If you chose a custom installation, the VBA components may have been deselected. Step-by-Step Solutions to Restore Macro Functionality 1. Download and Install the WPS VBA 7.1 Add-in
To run macros, you need to install the specific VBA module compatible with WPS.
Find the Module: Search for the WPS VBA 7.1 support package on the official WPS website or trusted developer forums.
Install: Close all WPS applications (Writer, Spreadsheets, Presentation) before running the installer. How to Fix "WPS Office Macros Cannot Be
Verify: After installation, restart WPS Office. A Developer tab should now appear in the ribbon menu. 2. Enable the Developer Tab and Macro Settings
If the library is installed but macros still won't run, you may need to manually enable the interface and security permissions.
The error message "WPS Office macros cannot be run because the VBA support library is not installed" occurs because the standard free or personal versions of WPS Office do not include the Visual Basic for Applications (VBA) runtime environment by default.
To resolve this, you must manually install the VBA support module or upgrade to a version that includes it. How to Fix the Missing VBA Support Library
Download and Install the VBA Add-inSince WPS does not provide this package directly in the free version, you need to obtain the WPS VBA 7.1 (or later) add-in.
Official Method: Some users can download it through the WPS Office Academy or by registering for a VIP Member Service plan.
Community Workaround: Many users find the installer (often named VBAxWPS.exe or vba_for_wps_1033.exe) through developer forums or shared repositories like Reddit.
Installation Step: Ensure all WPS Office applications are closed before running the installer. What Does This Error Mean
Enable the Developer TabOnce the library is installed, you may need to manually enable the macro tools in the interface: Open WPS Spreadsheets (or Writer). Go to Menu > Options. Select Customize Ribbon. Find Developer in the list of main tabs and check the box.
Click OK. You should now see a Developer tab with macro options.
Adjust Macro Security SettingsIf the library is installed but macros still won't run, check your security settings:
Navigate to Developer > Macro Security (or through Options > Trust Center).
Select Enable all macros or Enable macros with notification. Important Considerations
To resolve the "macros cannot be run because the VBA support library is not installed" error in WPS Office, you typically need to install the WPS VBA Runtime , as it is not included in the standard free version. Proposed Feature: "One-Click Macro Bridge"
Instead of requiring manual installation of external DLLs or plugins, WPS Office should implement a One-Click Macro Bridge Integrated Installer
: A built-in prompt that automatically downloads and installs the required VBA support library directly within the app when an or macro-enabled file is first opened. JS-to-VBA Transpiler VBA is the programming language used by Microsoft
: A feature that automatically converts legacy VBA code into WPS JS Macros
. This would allow macros to run natively in WPS Office's JavaScript-based editor without needing the legacy VBA library. Cloud-Sync Modules
: Instead of local library dependencies, the "Bridge" could host standard VBA libraries in the
, allowing macros to execute in a sandboxed environment regardless of local installation. How to Fix the Current Error
If you are currently facing this issue, you can try the following steps: How to Enable Macros in WPS Office
WPS Office (Writer, Spreadsheets, and Presentation) is a popular, lightweight, and free alternative to Microsoft Office. However, not all versions of WPS include VBA (Visual Basic for Applications) support by default.
When you see the error, WPS is telling you: “I see you’re trying to run a macro, but I lack the engine needed to interpret that VBA code.”
Below are four proven methods to resolve the missing VBA library error.
If you’ve tried all methods and the error persists, consider these final options:
LibreOffice Basic). Compatibility is not perfect, but it often runs simple macros.wps.com (not a third-party site). During installation, choose Custom Install and ensure “VBA Components” is checked.