How to Run Macros in WPS on Windows

Use Run Macro with 4 how-to topics, including running an existing macro, creating a macro, deleting a macro, and recording a new macro; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Run an Existing Macro

Entry point: Developer Tools → Run Macro

1. Click Run Macro on the Developer Tools tab.
2. Select the macro you want to run from the macro list.
3. Click Run to execute the macro.

Success Criteria

• UI state: The macro list opens and shows available macros.
• Next actions: The selected macro starts running and the spreadsheet updates as expected.

Tips While Using

• Common mistakes: Clicking Run before selecting the correct macro.
• Environment limits: If the VBA plugin is not installed, the related entry may be unavailable.

2. Create a Macro

Entry point: Developer Tools → Run Macro → Create

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

Success Criteria

• UI state: WPS accepts the new macro name and opens the next creation or editing step.
• Next actions: You can continue writing or maintaining the macro.

Tips While Using

• Common mistakes: Using duplicate or unclear macro names, which makes later management harder.
• Environment limits: Confirm that the VBA plugin is installed before you start.

3. Delete a Macro

Entry point: Developer Tools → Run Macro → Delete

1. Click the Developer Tools tab.
2. Click Run Macro.
3. Select the macro you want to delete from the list.
4. Click Delete.

Success Criteria

• UI state: The deleted macro no longer appears in the macro list.
• Next actions: You can continue managing other macros.

Tips While Using

• Common mistakes: Deleting a macro before confirming what it is used for.
• Environment limits: Deleted macros are not typically restored directly, so confirm before removing one.

4. Record a New Macro

Entry point: Developer Tools → Record New Macro

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

Success Criteria

• UI state: After recording ends, the new macro appears in the macro list.
• Next actions: You can run the recorded macro again from Run Macro.

Tips While Using

• Common mistakes: Recording unrelated actions, which changes the final result of the macro.
• Environment limits: Macro names support letters, numbers, and underscores.