Find answers to 3 common Macro Security questions on macOS, including setting changes, macro prompts, and trusted locations, plus a short glossary.
FAQ
Why did my Macro Security changes not take effect?
- Make sure you clicked OK to save the setting.
- Close all open WPS documents.
- Quit and restart WPS.
- Open the file again and check the macro behavior.
How do I enable macros when a file says macros are disabled?
- Open the file and check whether a security warning bar appears at the top.
- If you want to allow macros for the current file, click Enable Content.
- If you need a longer-term change, open Macro Security and adjust the security level.
- Reopen the file and confirm that the macro runs as expected.
How do I add a specific folder as a trusted location?
- Open File in the upper-left area.
- Go to Options → Trust Center → Trusted Locations.
- Add the folder path that you want to trust.
- Save files in that location and reopen them to verify the result.
Glossary
| Term | Definition |
|---|---|
| Macro security level | A security policy level that controls whether macros can run and how they are handled. |
| Trusted publisher | A trust-related setting used to determine whether specific macro or project access can be allowed. |
| WPS JS macro | The macro type supported by WPS Spreadsheet on macOS, based on WPS JavaScript macro capabilities. |