In the modern office environment, automation is king. Macros—small programs written in Visual Basic for Applications (VBA)—are the workhorses that turn repetitive spreadsheet calculations, document formatting, and data processing tasks into single-click operations. When a user encounters the error message, "WPS Office macros cannot be run because the VBA support library is not installed," they are not merely facing a technical glitch. They are hitting a fundamental architectural and licensing reality of the WPS Office ecosystem. This essay explores the causes, implications, and solutions surrounding this error, revealing a critical compatibility layer between two office suite giants: Microsoft Office and WPS Office.
| Solution | Works in WPS Free | Works in WPS Pro | Requires purchase | |----------|------------------|------------------|--------------------| | Install VBA add‑in | ❌ | ✅ | ✅ (Pro license) | | Upgrade to WPS Pro | ✅ (by upgrading) | ✅ | ✅ | | Switch to MS Office | N/A | N/A | ✅ (unless already owned) | | View only (no macros) | ✅ | ✅ | ❌ |
If you need further assistance, contact WPS support or check your license type under Menu → Help → About WPS Office.
To fix the "macros cannot be run because the VBA support library is not installed" error in WPS Office, you must download and install the external VBA support module
, as WPS Office does not include it by default in the free version. 1. Install the VBA Support Library
WPS Office requires a separate installation of the Visual Basic for Applications (VBA) environment to recognize and execute macros. Close WPS Office
: Ensure all WPS applications (Writer, Spreadsheets, Presentation) are completely closed before starting. Download the VBA Module : Search for and download a WPS VBA 7.1 VBA for WPS installer from the official WPS Academy or trusted community forums. Run the Installer : Follow the on-screen prompts to install the library. Restart WPS Office
: Reopen your document; the "Developer" tab should now be active, and the error should disappear. WPS Office 2. Enable Macros in Settings
Once the library is installed, you must permit WPS to run the code by adjusting security settings. WPS Spreadsheets (or Writer/Presentation). button (top-left) and select Trust Center Trust Center Settings Macro Settings and choose Disable all macros with notification (recommended) or Enable all macros and restart the application. WPS Office 3. Check Your File Format In the modern office environment, automation is king
Macros can only run in specific file formats. If your file is saved as a standard , the macros may be stripped out or blocked. WPS Office Ensure the file type is set to Excel Macro-Enabled Workbook (.xlsm) Important Limitations How to Fix Macros Not Working in Excel [Step-by-Step]
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.
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. If you need further assistance, contact WPS support
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. Once you have fixed the issue, follow these
Once you have fixed the issue, follow these best practices to avoid recurrence:
The error "Macros cannot be run because the VBA support library is not installed" is simply a missing component issue.
Have you tried these fixes? Did you find a different solution in the WPS forums? Let us know in the comments below to help other users!
Tags: #WPSOffice #VBA #ExcelMacros #TechSupport #Productivity #SoftwareFix
Try reinstalling WPS Office completely, then install the VBA plugin immediately after before opening any file. Also, ensure your Windows system has the latest Visual C++ Redistributables installed.
If you have WPS Office Professional (paid), you can install the VBA support library separately:
Note: The free version does not support this add‑in. Trying to install it on free WPS will either fail or prompt you to upgrade.
No. In 99% of cases, the file is fine. The problem is your WPS Office environment is missing the necessary interpreter to read and execute the VBA code inside the macro.