The error message "WPS Office macros cannot be run because the VBA support library is not installed" occurs because WPS Office, unlike Microsoft Office, does not always include the Visual Basic for Applications (VBA) environment by default. This functionality is typically reserved for the WPS Office Professional/Business editions or requires a separate manual installation of the VBA support package. Common Causes
Version Limitation: The free or personal versions of WPS Office often do not include the VBA engine required to execute .xlsm or macro-enabled files.
Missing Plugin: Even in some paid versions, the VBA support library might not be selected during the initial installation.
Incompatible File Format: Attempting to run macros in a standard .xlsx file will fail, as macros require the .xlsm format. Recommended Solutions
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.
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
This error occurs because the standard free version of WPS Office does not include the Visual Basic for Applications (VBA)
environment by default. To run macros, you must either upgrade to a version that includes it or manually install the missing plugin. WPS Office Primary Solutions Upgrade to WPS Office Pro/Business The error message " WPS Office macros cannot
: The most reliable way to get VBA support is by using a version that natively includes the package, such as the WPS Office Business Install the VBA Support Library Plugin : You can manually add VBA functionality by downloading the WPS VBA 7.1 (or version 6.0+) package from the WPS Academy or other trusted sources. Close all WPS Office applications before installing. Run the installer (often named vba6chs.msi or similar) and follow the prompts. Restart WPS Office; the tab should now be visible and functional. WPS Office Alternative Troubleshooting Steps
If the library is installed but macros still won't run, check your security settings:
How to Download VBA Support Library for Office (A Detailed Guide) 19-Dec-2024 —
How to Fix: WPS Office Macros Cannot Be Run Because the VBA Support Library is Not Installed
If you have encountered the error message "WPS Office macros cannot be run because the VBA support library is not installed," you are likely trying to run an automated script or a macro-enabled file (like .xlsm) in WPS Spreadsheets or Writer.
Unlike Microsoft Office, which typically includes the Visual Basic for Applications (VBA) environment by default, WPS Office often requires a separate installation or a specific version to enable this functionality. Why This Error Occurs
The primary reason for this error is that the VBA environment is missing from your current installation.
Free vs. Premium: Historically, WPS Office included VBA support primarily in its Professional or Enterprise editions.
Missing Plugin: Even if your version supports it, the specific VBA plugin might not have been selected during the initial installation wizard.
Architecture Mismatch: Using the UWP version (from the Microsoft Store) often lacks macro support compared to the standard EXE installer. Step-by-Step Solutions to Fix VBA in WPS Office 1. Download and Install the VBA Support Library
To fix the "library not installed" error, you must manually add the VBA components.
Locate the Installer: Look for a file named VBAxWPS.exe or Visual Basic for Applications v7.1. Installation Process: Close all open WPS Office applications.
Run the VBAxWPS.exe installer with administrative privileges. Follow the on-screen prompts to complete the setup. Restart WPS Office and check the Developer tab. 2. Enable the Developer Tab and Macros
Once the library is installed, you must ensure the interface and security settings allow macros to run.
The error message "macros cannot be run because the VBA support library is not installed" typically occurs because WPS Office Personal/Free editions do not include Visual Basic for Applications (VBA) by default. While WPS Office is highly compatible with Microsoft Office formats, VBA is a proprietary Microsoft technology that WPS must license separately, which is why it is generally reserved for paid or enterprise versions. 1. Root Cause: Edition Limitations
The most common reason for this error is that you are using a version of WPS Office that lacks the VBA module. WPS Free/Personal: Does not natively support VBA macros. Search for the file: Perform a web search
WPS Professional/Enterprise: These editions often include the necessary VBA support library.
Missing Plugin: Even in some versions that could support it, the "VBA for WPS" plugin might not have been included in the initial installation. 2. Primary Fix: Install the VBA Support Library
To run macros, you must manually add the VBA environment to your WPS installation.
Official WPS VBA 7.1: You can download the WPS VBA 7.1 add-in directly from the WPS Academy or official WPS Support pages.
Installation Process: Ensure WPS Office is completely closed before running the installer. Once installed, the "Developer" tab should become active, providing access to the Visual Basic Editor and Macro settings.
Verification: Press Alt + F11 inside WPS Writer or Spreadsheets. If the VBA Editor opens, the library is correctly installed. 3. How to Enable Macros After Installation
Once the library is present, you must enable the functionality within the software: Open WPS Spreadsheets or Writer. Go to the Menu (top-left) and select Options.
Choose Customize Ribbon and ensure the Developer tab is checked.
Navigate to the Developer tab on the main ribbon and click Macro Security to allow macros to run (choose "Disable all macros with notification" for a balance of security and function). 4. Compatibility Warnings
Even with the library installed, compatibility is not 100% identical to Microsoft Excel.
Standard VBA: Most basic automation and standard commands will work.
Complex APIs: Macros that make deep calls to unique Microsoft Office APIs or specific ActiveX controls may still fail or require code "tweaks".
Alternatives: For users who cannot get VBA working, LibreOffice is an open-source alternative that supports VBA macros natively without additional paid plugins.
The error "macros cannot be run because the VBA support library is not installed" in WPS Office occurs because the standard free version does not include the Visual Basic for Applications (VBA) engine by default . To resolve this, you must
manually install the VBA support module or upgrade to a version that supports it Solution 1: Install the WPS VBA 7.1 Add-in
Since WPS Office does not provide a built-in VBA package in most free versions, you need to download and install it separately. Download the Module or support articles.
: Search for the "WPS VBA 7.1" or "vba7.msi" installer from the WPS Academy or trusted developer communities.
: Close all WPS Office applications before running the installer. Once finished, restart WPS. : Open WPS Spreadsheets, navigate to the tab, and check if the Visual Basic buttons are now clickable. Solution 2: Enable the Developer Tab
If the library is installed but you cannot see the macro options, you may need to enable the ribbon tab: Customize Ribbon and check the box. to move Macros into your main ribbon view and click Solution 3: Version Compatibility Personal vs. Enterprise
: Some older reports suggest macros are primarily supported in the Enterprise Edition or specialized versions purchased through distributors. Microsoft Office Presence
: On some systems, the Developer tab only becomes active if a version of Microsoft Office with a VBA environment is also present on the machine. Ask Ubuntu Alternative for Linux Users
For those using WPS Office on Linux (e.g., Ubuntu), standard VBA support is often missing. Users typically need to seek third-party community packages or use the Enterprise version to enable full macro functionality. Ask Ubuntu download link to the official VBA 7.1 support package or help troubleshooting a specific macro error code?
If the official plugin store doesn't have it or the update button is greyed out, this is the most common fix used by power users. This involves manually installing the VBA support library file.
Disclaimer: Only download files from reputable sources to ensure your computer's security.
You have three options, depending on your needs and budget.
The error “WPS Office macros cannot be run because the VBA support library is not installed” is not a bug—it’s a missing feature. In most cases, installing the dedicated WPS VBA plugin solves the problem instantly. If you cannot use the plugin, upgrading to a paid version of WPS is your next best bet.
For professional users who rely heavily on VBA automation (financial models, data processing, legacy business macros), switching to Microsoft Office may ultimately be the most headache-free solution. However, for light to moderate macro usage, the steps above will get WPS running your VBA code without further issues.
Have questions or other WPS macro errors? Leave a comment below or visit the official WPS Community Forums for advanced troubleshooting.
| Step | Action | |------|--------| | ✅ | Download & install official WPS VBA add-in | | ✅ | Restart WPS Office | | ✅ | Enable macros in Trust Center settings | | ✅ | Upgrade to Professional if needed | | ✅ | Switch to MS Office for heavy macro use |
If you continue to see the error after installing the VBA library, please specify:
Then I can provide more targeted assistance.
Here’s a help piece you can use or adapt for user documentation, troubleshooting guides, or support articles.
There are three primary scenarios that trigger this specific error message: