Saturday, May 09, 2026
Run the installer and select the "Repair" or "Modify" option.
To resolve the error "macros cannot be run because the VBA support library is not installed" in WPS Office, you must install the (vba6.exe or vba7.1) manually or upgrade to a version that includes it .
| Suite | VBA Support | Cost | Compatibility | |--------|--------------|-------|----------------| | Microsoft Office 365 / 2021 | ✅ Full native VBA | Subscription or one-time | 100% | | LibreOffice | ⚠️ Limited (requires LibreOffice Basic — different syntax) | Free | Partial | | OnlyOffice | ❌ No VBA | Free (Desktop) | No | | SoftMaker Office | ✅ Includes VBA support | Paid (affordable) | High | Run the installer and select the "Repair" or "Modify" option
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
WPS Office shows "macros cannot be run because the VBA support library is not installed" (or similar). That means WPS lacks the Visual Basic for Applications runtime or its VBA integration component, so macros (VBA) in the document cannot execute. Download the Module WPS Office shows "macros cannot
The standard free version of WPS Office often excludes the environment to save space and licensing costs. 🛠️ Quick Solutions 1. Upgrade to WPS Professional
: 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 🛠️ Quick Solutions 1
"WPS Office macros cannot be run because the VBA support library is not installed"
Depending on whether you want an official upgrade or a quick workaround, use one of the following methods to restore macro functionality.
Click on or Visual Basic Editor (which defaults to JS in newer versions).
