WPS Office blocks macros by default to protect your computer from malicious scripts.

Ensure you are saving your files in a format that supports macros, such as . If you try to run macros in a standard file, you will receive errors.

Another popular variant is simply named "VBA for WPS Office 7.0". It is available on various software download portals. This version is known for being stable with "winall" environments (various Windows OS) and has a history of over 12,000 downloads, indicating a high level of community trust.

If the Developer tab is visible but the VBA options cannot be clicked, WPS Office is failing to locate the library.

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.

Without the VBA support library, opening a macro-enabled workbook ( .xlsm or .xls ) in WPS Office will result in: Greyed-out macro buttons in the tab.

img
Conversations
img
img
Typing....
close
Privacy Notice

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you accept and understand our Privacy Settings.

Please wait…