WPS Macro Security on Windows: Introduction

WPS Macro Security is a security feature for managing macro execution permissions and trust settings in WPS Spreadsheet; it includes 5 core tasks, with 5 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	5	Matches the number of rows in the How-to Index
Available without membership	5	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Version requirement	VBA plugin required	Prepare the related component before using macro features

About This Feature

Overview

Macro Security is used to set macro execution policies in WPS Spreadsheet so you can balance security control with ease of use. You can adjust security levels in Trust Center, manage trusted publisher related options, and control how macros are enabled through the security warning bar or trusted locations.

Core capabilities include:

Set macro security levels to control default macro behavior.
Manage trusted publisher related options.
Enable macros for the current file through the security warning bar.
Reduce repeated prompts with trusted locations.
Restart WPS after changes so settings take effect.

System Requirements

Item	Requirement
Operating system	Windows device
App version	It is recommended to use the latest version of WPS Office with Spreadsheet available
Component requirement	Install the VBA plugin before using macro-related features
Network	No mandatory internet connection is required for local macro security settings; internet access is needed for download and installation
Other	You need permission to open Developer Tools and Trust Center related settings

Source: System Requirements for WPS Office

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation notes	Download and install WPS Office for Windows, then confirm that the VBA plugin is installed before using macro-related features
Post-install check	Open WPS Spreadsheet and check whether the Macro Security entry is available on the Developer tab

Source: WPS Office Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides macro security level settings, trusted publisher related options, and macro control through the security warning bar and trusted locations.	Microsoft 365 provides Trust Center macro settings, trusted documents, and trusted locations to control how macros are enabled in Office files.	Google Sheets supports recording and running macros, and recorded macros create Apps Script, with a focus on automation rather than layered local macro security settings.	Notion uses buttons and automation actions for repetitive tasks, with some paid actions, but it does not provide traditional document macro security level management.	Acrobat restricts JavaScript API access and uses trust-related controls for active content risk management, focusing on PDF and script security.
WPS Advantages	Advantage: WPS lets you open macro security settings directly from Developer Tools in WPS Spreadsheet. Distinct: It combines security levels, trust options, and common enablement paths in one workflow.	Compared with WPS: Microsoft offers broader Trust Center controls across Microsoft 365 apps, but users also need to distinguish between trusted documents and trusted locations.	Compared with WPS: Google is more oriented to online spreadsheet automation; its official guidance focuses on macros as Apps Script rather than desktop trust-center style macro security levels.	Compared with WPS: Notion is designed for page and database automation, not spreadsheet macro enablement, disablement, or trusted location management.	Compared with WPS: Adobe focuses on PDF JavaScript and web access controls instead of spreadsheet macro execution policies.
Official Source	—	Enable or disable macros in Microsoft 365 files; Add, remove, or change a trusted location in Microsoft Office	Automate tasks in Google Sheets	Buttons	Restrict JavaScript API access in Acrobat

Overall Conclusion
If your main goal is to manage macro execution risk inside WPS Spreadsheet, WPS Macro Security provides a direct entry point and settings that fit spreadsheet use more closely. For online automation, page workflows, or PDF script controls, these products cover different objects and use cases.

Use Cases

No.	Scenario	Suitable users	Main issue	How it helps
1	Set a security level before opening a macro-enabled file	Finance, operations, and data users	You are not sure whether macros in external files are safe	Open Macro Security first and choose an appropriate security level before opening the file
2	Trust macros only from specific sources	Teams that use internal templates regularly	You do not want to confirm the same files every time	Use trusted publisher related options or trusted locations for recurring file sources
3	Enable macros only for one file	Users who only occasionally receive macro-enabled spreadsheets	You want to allow one file without lowering global security	Use the security warning bar at the top of the window to enable content for the current file
4	Confirm whether changes took effect	All macro users	The behavior does not change after editing settings	Save the settings, close documents, and restart WPS
5	Manage access for development work	Advanced users who debug macro projects	You need project access but want to avoid opening permissions unnecessarily	Turn on the related trust options only when needed

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic Macro Security settings	✅ Available	✅ Available
Macro security level adjustment	✅ Available	✅ Available
Trusted publisher related settings	✅ Available	✅ Available
Cloud storage and added benefits	Basic benefits	More added benefits are listed on the official pricing page

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
You only need local macro security management	Free	Macro Security itself has no membership restriction and fits everyday spreadsheet security management
You also need more cloud storage or other added capabilities	WPS Premium	Suitable if you need more cross-device or advanced benefits beyond Macro Security

WPS membership center: Subscribe now