How to Use WPS Developer Tools on macOS

Use WPS Developer Tools through 5 how-to topics, all available without membership; open the index below to jump to the task you want to complete.

How-to Index

How-to Guide

1. Open the Developer Tools tab

Feature entry: Tools → Developer

1. Open WPS Spreadsheet and go to the workbook you want to work with.
2. Click the Tools tab at the top.
3. Click the Developer button.
4. Check whether the Developer Tools tab appears in the top ribbon area.

Success Criteria

• Interface result: The Developer Tools tab appears in the top ribbon.
• What you can do next: You can continue to access Run Macro, Record New Macro, Macro Security, and WPS Add-ins.

Tips While Using

• If the current window is not in spreadsheet editing mode, the related entry points may not appear as expected.
• On Mac, the current feature scope mentions support for WPS Macros only, which are JS macros.

2. Find the Run Macro entry

Feature entry: Developer Tools → Run Macro

1. First open the Developer Tools tab by following the previous section.
2. Click the Developer Tools tab.
3. Find the Run Macro button in the tab.
4. Click it to view the existing macro list or available execution entry.

Success Criteria

• Interface result: The Run Macro window or entry becomes visible.
• What you can do next: You can choose an existing macro and prepare to run it.

Tips While Using

• Before running a macro from an unfamiliar source, review its purpose and content first.

3. Find the Record New Macro entry

Feature entry: Developer Tools → Record New Macro

1. Open the Developer Tools tab.
2. Find the Record New Macro button.
3. Click the button to prepare for recording your next spreadsheet actions.
4. Perform the actions that you want to record.

Success Criteria

• Interface result: You enter the setup or recording state for a new macro.
• What you can do next: You can start capturing repeated actions for later use.

Tips While Using

• Before recording, outline the steps you want to automate so the result is easier to reuse later.

4. Find the Macro Security entry

Feature entry: Developer Tools → Macro Security

1. Open the Developer Tools tab.
2. Find the Macro Security button.
3. Click the button.
4. Review the current settings related to macro execution permissions.

Success Criteria

• Interface result: The macro security settings page or options become visible.
• What you can do next: You can review or adjust the macro execution policy as needed.

Tips While Using

• When working with macros in external files, review the security settings before running them.

5. Find the WPS Add-ins entry

Feature entry: Developer Tools → WPS Add-ins

1. Open the Developer Tools tab.
2. Find the WPS Add-ins button.
3. Click the button.
4. Review the available add-in management entry.

Success Criteria

• Interface result: The WPS Add-ins management entry becomes visible.
• What you can do next: You can continue to review or manage related add-ins.

Tips While Using

• Some add-in functions may depend on your network status or account status.