Wps Office Macros Cannot Be Run Because The Vba Support Library Is Not Installed Hot [NEW]

If you are reading this post, you have likely just encountered one of the most frustrating errors in WPS Office. You downloaded a spreadsheet with powerful automation, you try to run a macro, and instead of magic, you get a generic error message:

"Macros cannot be run because the VBA support library is not installed."

Don't panic. This does not mean your file is broken, nor does it mean you need to switch operating systems. It simply means your version of WPS Office is currently "light" on programming features. If you are reading this post, you have

In this post, we will walk you through exactly why this happens and the two easiest ways to fix it.


WPS Office (Writer, Spreadsheets, and Presentation) is a popular, lightweight, and free alternative to Microsoft Office. However, not all versions of WPS include VBA (Visual Basic for Applications) support by default. "Macros cannot be run because the VBA support

When you see the error, WPS is telling you: “I see you’re trying to run a macro, but I lack the engine needed to interpret that VBA code.”

To understand the fix, you have to understand how WPS Office is built. Unlike Microsoft Office, which installs almost everything by default, WPS Office prioritizes speed and a smaller file size. Don't panic

The Reason: By default, the standard (free) installation of WPS Office does not include the VBA (Visual Basic for Applications) Runtime Environment. It has the ability to run macros, but it lacks the specific "engine" (the support library) required to execute the code.

Think of it like buying a car, but the manufacturer didn't install the fuel lines to save weight. You have the car (WPS) and the fuel (your Macro), but they can't connect.