Feature Summary
Run Macro can automatically execute recorded macro operations, enabling batch processing of repetitive tasks and significantly improving spreadsheet editing efficiency.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction; VBA plugin installation required |
Operation Steps
Run an Existing Macro
Feature Entry
"Tools" tab → "Developer Tools" button → "Developer Tools" tab → "Run Macro" button
- Click the "Tools" tab at the top, locate and click the "Developer Tools" button to bring up the "Developer Tools" tab at the top
- Click the "Run Macro" button in the "Developer Tools" tab
- Select the macro name you want to run from the pop-up macro list
- Click "Run" to automatically execute all operations contained in the macro


Create a Macro
Feature Entry
"Developer Tools" tab → "Run Macro" button → "Create" button
- Click the "Developer Tools" tab
- Click the "Run Macro" button
- Enter a macro name and click "Create" to finish creation

Record a New Macro
Feature Entry
"Developer Tools" tab → "Record New Macro" button
- Click the Record New Macro button in the Developer Tools tab
- Enter a macro name (only English letters, numbers, and underscores are supported); you can set a shortcut key
- Start performing the repetitive operations you want to automate
- After completing the operations, click Stop Recording to save the macro

FAQ
Q1: What should I do if the macro code is lost when saving the file?
- Solution: Files containing macros need to be saved in the "Macro-Enabled Workbook (*.xlsm)" format; the regular xlsx format will cause macro code to be lost.
Q2: Can I run macros from unknown sources?
- Solution: It is not recommended. Macros from unknown sources may carry virus code. Confirm that the file source is trustworthy before running.
Notes
- Mac/Linux systems have limited support for WPS macros; using Windows is preferentially recommended.