How to Run Macro in WPS on macOS

Use Run Macro in WPS on macOS through 4 how-to topics; 4 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Run an Existing Macro

Feature entry: Developer → Run Macro

1. Click the Developer tab and select Run Macro.
2. In the macro list, select the macro you want to run.
3. Click Run to execute the saved macro steps.

Success Criteria

• The selected macro starts running.
• The spreadsheet responds according to the saved macro steps.

Tips While Using

• Confirm the macro name before running it.
• If no macro is available in the workbook, there will be nothing to run from the list.

2. Create a Macro

Feature entry: Developer → Run Macro → Create

1. Click the Developer tab.
2. Select Run Macro.
3. Enter a macro name.
4. Click Create to finish creating the macro.

Success Criteria

• The new macro entry is created successfully.
• You can continue with later macro editing or maintenance.

Tips While Using

• Use a clear macro name so it is easier to identify later.
• Check whether a similar macro already exists before creating a new one.

3. Delete a Macro

Feature entry: Developer → Run Macro → Delete

1. Click the Developer tab.
2. Select Run Macro.
3. Choose the macro you want to remove.
4. Click Delete.

Success Criteria

• The selected macro is removed from the list.
• The macro list refreshes without the deleted item.

Tips While Using

• Confirm the selected macro before deleting it.
• Review the macro name carefully to avoid removing the wrong item.

4. Record a New Macro

Feature entry: Developer → Record New Macro

1. Click Record New Macro on the Developer tab.
2. Enter a macro name and set a shortcut if needed.
3. Perform the repeated actions you want to automate.
4. Click Stop Recording when finished to save the macro.

Success Criteria

• The recorded macro appears in the macro list afterward.
• You can run the recorded macro again later.

Tips While Using

• Macro names support letters, numbers, and underscores.
• Plan the action order before recording so the result is easier to reuse.