How to Record New Macro in WPS on Windows

Last updated:July 15, 2026

Use Record New Macro with 3 how-to topics, including recording a macro, stopping recording, and editing a recorded macro; 3 items are available without membership and 0 items are membership-related.

How-to Index

#TopicMembership
11. Record a MacroFree
22. Stop Recording a MacroFree
33. Edit a Recorded MacroFree

How-to Guide

1. Record a Macro

Entry point: Tools → Developer → Record New Macro

  1. Click Developer in the Tools tab.
  2. In the Developer tab, click Record New Macro.
  3. Enter a macro name in the dialog box.
  4. Choose the save location as Current Document or All Documents.
  5. Click OK to start recording.
  6. Perform the actions you want to capture.

Success Criteria

  • UI state: The app enters macro recording mode.
  • Next actions: You can continue performing the document actions that should be recorded.

Tips While Using

  • Common mistakes: The macro name must start with a letter and can only include letters, numbers, and underscores.
  • Environment limits: VBA macros require the VBA plug-in on Windows, and mobile platforms do not support macro recording.

2. Stop Recording a Macro

Entry point: Developer → Stop Recording

  1. After you finish the actions you want to capture, return to the Developer tab.
  2. Click Stop Recording to end the current recording.

Success Criteria

  • UI state: Recording mode ends and later actions are no longer captured.
  • Next actions: The recorded macro is ready for later playback or editing.

Tips While Using

  • Common mistakes: Extra clicks before stopping are also recorded, so keep the recording process focused on the target actions.

3. Edit a Recorded Macro

Entry point: Developer → Run Macro → Edit

  1. Open the macro-related entry in Developer.
  2. Click Run Macro.
  3. Select the recorded macro.
  4. Click Edit to open the VBA Macro Editor or the WPS Macro Editor.

Success Criteria

  • UI state: The corresponding macro editor opens successfully.
  • Next actions: You can review, modify, or extend the macro code.

Tips While Using

  • Common mistakes: If you have not completed recording first, the target macro will not appear in the list.
  • Environment limits: Different macro types may open in different editors.