Extra Quality - Wps Office Macros Cannot Be Run Because The Vba Support Library Is Not Installed Hot
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
Install the VBA Add-on (Commercial Version): Kingsoft offers a separate VBA support package, but it is not free. Users who purchase a commercial license of WPS Office Professional can download and install the VBA add-on. This installs a licensed version of the VBA runtime that works within WPS. Once installed, the error disappears, and macros run as intended. This is the simplest fix for organizations already invested in WPS. The error message "macros cannot be run because
If you need guaranteed compatibility:
- Note: The plugin is sometimes listed under "Tools" or "Add-ins".
- Use LibreOffice – Free, open-source, and supports VBA macros with its own runtime (
LibreOffice Basic). Compatibility is not perfect, but it often runs simple macros. - Use Microsoft Office Online – The web version does not run VBA macros at all, so not ideal.
- Reinstall WPS from a different source – Download the international full installer from
wps.com(not a third-party site). During installation, choose Custom Install and ensure “VBA Components” is checked.
WPS Office: “Macros cannot be run because the VBA support library is not installed”
What causes this error?
WPS Office Free version does not include built‑in VBA (Visual Basic for Applications) support. When you try to run or open a file containing macros (.xlsm, .docm, .pptm, or files with VBA code), you’ll see: Note: The plugin is sometimes listed under "Tools"