WPS Macro Security helps control macro execution in WPS Spreadsheet on macOS; this guide covers 2 core tasks, with 2 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 2 | Matches the number of rows in the How-to Index |
| Available without membership | 2 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
Macro Security is a built-in security control in WPS Office for Mac for WPS Spreadsheet. It is used to manage macro execution permissions so you can balance security and convenience when opening or working with macro-enabled spreadsheets. On macOS, only WPS macros (JS macros) are supported.
Core capabilities include:
- Set macro security levels to control whether macros can run under different risk levels.
- Manage trusted publisher access for WPS JS project access.
Common use cases include reviewing spreadsheets with macros, managing internal spreadsheet automation, and reducing risk from unknown macros.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A macOS device that can run WPS Office for Mac |
| App version | It is recommended to use the latest version of WPS Office for Mac |
| Network | No mandatory internet connection is required to change local macro security settings |
| Other | You need to open WPS Spreadsheet and access the Developer tab |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Spreadsheet and confirm that the Macro Security button is available on the Developer tab |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Provides macro security level settings and trusted publisher access settings in WPS Spreadsheet on macOS; macOS supports WPS macros (JS macros) only. | Microsoft 365 apps provide Trust Center macro settings, including disabling macros, enabling them with notification, allowing digitally signed macros, and trusted documents or trusted locations. | Google Sheets supports recording and running macros, and creating an Apps Script when a macro is created, with a focus on cloud automation rather than a desktop trust center for macro security levels. | Notion buttons automate page and database actions, notifications, and other workflows, with some actions limited to paid plans; it does not provide spreadsheet macro security level controls. | Acrobat provides enhanced security controls and JavaScript-related security settings for PDF content and web access, rather than spreadsheet macro execution management. |
| WPS Advantages | Advantage: Macro execution settings are managed directly inside WPS Spreadsheet on macOS. Distinct: It also includes an access control option for WPS JS projects in the same area. | Compared with WPS: Microsoft focuses on VBA-oriented macro controls, trusted documents, and trusted locations across Microsoft 365 apps. | Compared with WPS: Google focuses on web-based macro recording and Apps Script editing instead of a local macro security center for desktop spreadsheets. | Compared with WPS: Notion automation is designed for workspace actions and database workflows, not spreadsheet macro security policies. | Compared with WPS: Adobe security settings are designed for PDFs and JavaScript-related access, not spreadsheet macro run policies. |
| Official Source | — | Enable or disable macros in Microsoft 365 files | Automate tasks in Google Sheets | Buttons | Enable enhanced security in Acrobat |
Overall Conclusion
If you need to manage whether macros can run directly in WPS Spreadsheet on macOS, Macro Security provides a focused in-app entry point for that task. Other products also offer automation or security controls, but they target different file types, scripting models, or workflow scenarios.
Use Cases
| No. | Scenario | Suitable For | Main Need | How Macro Security Helps |
|---|---|---|---|---|
| 1 | Review a macro-enabled spreadsheet before opening it fully | General office users | You are not sure whether the file contains safe macros | Raise the macro security level before working with the file |
| 2 | Manage internal spreadsheet automation | Team members | You need a balance between security and efficiency | Choose a suitable macro security level for the workflow |
| 3 | Work with WPS JS macro projects | Advanced users | You need to control access to WPS JS projects | Turn on the related access option in Trusted Publishers |
| 4 | Open files from external sources | Finance, operations, and similar roles | External files may contain untrusted macros | Use a higher security level to limit macro execution |
| 5 | Verify that a setting change has taken effect | All users | You want to confirm the new setting is active | Save the setting, restart WPS, and test the file again |
Membership & Benefits
Free vs WPS Premium
| Feature | Free | WPS Premium |
|---|---|---|
| Macro Security settings | ✅ Available | ✅ Available |
| Basic PDF features | ✅ Available | ✅ Available |
| Cloud storage | 1 GB | 20 GB |
| Template downloads | Limited | More advanced template benefits |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| You only need to adjust macro security settings and handle everyday spreadsheets | Free | Macro Security itself is available without membership |
| You also need more cloud storage and broader premium benefits | WPS Premium | Suitable for cross-device work or users who need more value-added features |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page