Use WPS Macro Security with 3 how-to topics, all available without membership; choose a topic from the index and follow the entry path and steps.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Set Macro Security | Free |
| 2 | 2. Open Macro Security from Developer Tools | Free |
| 3 | 3. Set Trusted Locations | Free |
How-to Guide
1. Set Macro Security
Entry path: Tools → Macro Security
- Click the Tools tab at the top of the window.
- Select Macro Security.
- In the dialog box, choose a security level.
- Select Very High, High, Medium, or Low as needed.
- If needed, review the trusted publisher settings for signed macros.
- Click OK to save the setting.
Success Criteria
- Interface result: The Macro Security dialog opens and shows the available security level options.
- Next action available: When you open the dialog again, the saved setting is still shown.
Tips While Using
- Common mistake: Setting the level to Low reduces restrictions on macro execution, so use extra caution with external files.
- Environment note: Macro risk varies by file source, so confirm the source before lowering the security level.
2. Open Macro Security from Developer Tools
Entry path: Developer Tools → Macro Security
- Click the Developer Tools tab at the top of the window.
- Find and click Macro Security.
- Adjust the required security level in the dialog box.
- Click OK to save.
Success Criteria
- Interface result: The Macro Security settings window opens from the Developer Tools entry.
- Next action available: You can continue changing the security level or reviewing related trust settings.
Tips While Using
- Common mistake: If the Developer Tools tab is not visible, enable or display that tab first before continuing.
3. Set Trusted Locations
Entry path: File → Options → Trust Center
- Open the File menu in the upper-left corner.
- Click Options to open the related settings window.
- Select the Trust Center tab.
- Click Add New Location and choose the folder path you want to trust.
- If needed, select the option to trust subfolders of this location as well.
- Click OK to save.
Success Criteria
- Interface result: The target folder appears in the trusted locations list.
- Next action available: Macro files in that location can be handled under the current trust policy.
Tips While Using
- Common mistake: Do not add broad shared folders or folders with unclear file sources directly as trusted locations.
- Environment note: Trusted locations are more suitable for internal folders with clear control.