If you are getting the error "Macros cannot be run because the VBA support library is not installed," you are not alone. While is a powerful, free alternative to Microsoft Office, its support for Visual Basic for Applications (VBA) is not always active by default in every version.

Go to the Developer tab > Macro Security and ensure that "Disable all macros" is not selected.

Are you using a or Business version of WPS Office, as this often determines which library download you need?

Ensure you are saving your files as Excel Macro-Enabled Workbook (.xlsm) or Binary (.xlsb) . Standard .xlsx files do not support macros.