If you encounter the error message it means your current version of WPS Office lacks the necessary Visual Basic for Applications (VBA) environment required to execute automation scripts.
Sometimes the library is installed, but VBA is disabled in the trust center. Open WPS Spreadsheets. Click the button (top-left). Select Options . Go to the Security or Trust Center tab.
To fix the "library not installed" error, you must manually add the VBA components.
Most basic automation and standard commands will work. If you encounter the error message it means
Uninstall your current version of WPS Office and run the new installer.
VBA stands for , the programming language used by Microsoft Office to create macros—automated tasks that save time and increase productivity.
Ensure your file is saved in a macro-enabled format, such as .xlsm for spreadsheets. Click the button (top-left)
Microsoft Office comes with built-in VBA support. WPS Office, designed as a cross-platform and highly optimized alternative, excludes VBA from its free version to keep the installation file small and avoid licensing fees.
This error occurs because VBA (Visual Basic for Applications) support is not included in the standard installation of WPS Office. This guide will provide comprehensive, up-to-date solutions for resolving this issue in 2026. What is the VBA Support Library?
The is the essential component or plugin that allows the WPS software to interpret and execute this code. Without it, the "Macro" button in WPS Spreadsheet or Writer will either be grayed out or throw the error message when clicked. How to Fix "WPS Office Macros Cannot Be Run" To fix the "library not installed" error, you
Note: While JS macros are highly efficient, they use a different API than Microsoft's VBA. Existing Excel VBA code cannot be directly pasted here; it must be rewritten. Troubleshooting Common Installation Failures
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"
WPS Office is a powerful, lightweight alternative to Microsoft Office. Many users switch to it for its speed and cost-effectiveness. However, power users who rely on automation often hit a major roadblock when trying to run spreadsheets or documents containing macros. They are greeted with the frustrating error message:
: The free version of WPS Office (standard) generally lacks built-in VBA support to keep the installer size small.
Open your spreadsheet, and the macros should now work. Method 2: Reinstall/Modify via the Official Site