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.

In some regions or older versions, VBA support was historically a Premium/Professional

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 .

WPS Professional is typically a one-time purchase (~$80 USD) or an annual subscription for 365.