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.
These editions often include the necessary VBA support library. Try reinstalling WPS Office completely, then install the
Workarounds and suggestions
Even with the library installed, compatibility is not 100% identical to Microsoft Excel. Try reinstalling WPS Office completely