Go to Control Panel > Programs > Uninstall a program, and remove WPS Office.
: The free standard version of WPS Office often excludes the VBA module to keep the installer lightweight or to encourage professional upgrades.
Sometimes the library is there, but the interface isn't set up to use it. Open WPS Spreadsheets (or Writer). Customize Ribbon and ensure the tab is checked. tab now visible on your top ribbon, click Macro Settings , and select Enable all macros 2. Install the WPS VBA Add-in
Microsoft Office comes with built-in VBA support. WPS Office, designed as a cross-platform and highly optimized alternative, excludes VBA from its free version to keep the installation file small and avoid licensing fees.
WPS Office is not a Microsoft product. It is developed by Kingsoft. While WPS Office is largely compatible with Microsoft Office file formats ( .docx , .xlsx , .pptx ), including VBA support is a .
Once the library is installed, you must permit WPS to run the code by adjusting security settings. WPS Spreadsheets (or Writer/Presentation). button (top-left) and select Trust Center Trust Center Settings Macro Settings and choose Disable all macros with notification (recommended) or Enable all macros and restart the application. WPS Office 3. Check Your File Format
: A feature that automatically converts legacy VBA code into WPS JS Macros
