Run Macro in WPS on Windows: Introduction

Run Macro in WPS on Windows helps you run, create, delete, and record spreadsheet macros; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

Run Macro is an automation feature in WPS Spreadsheet for Windows. It helps you run saved macros, create new macros, delete macros you no longer need, and record a new set of repeated actions for later use. It is useful for recurring spreadsheet cleanup, repeated formatting, fixed data-entry routines, and regular report processing.

Core capabilities include:

Run an existing macro: Select a saved macro from the list and run it immediately.
Create a macro: Enter a macro name and start the creation flow.
Delete a macro: Remove macros that are no longer needed and keep the list organized.
Record a new macro: Capture repeated actions and save them as a reusable macro.

System Requirements

Item	Requirement
Operating system	A Windows device
App version	It is recommended to use the latest version of WPS Office
Network	Running local macros does not require a constant network connection; downloading, installation, and account-related actions require internet access
Other	Use WPS Spreadsheet with the Developer Tools entry available, and install the VBA plugin before using macro features

Download & Installation

Item	Details
Official Download	WPS Office Free Download
Post-install Check	Open WPS Spreadsheet and confirm that the Developer Tools tab is visible in the ribbon
Plugin Preparation	Install the VBA plugin before using macro features

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, you can run existing macros, create macros, delete macros, and record new macros after the VBA plugin is installed.	Microsoft Word supports recording and running macros, and macros can be assigned to a button or keyboard shortcut.	Google Sheets supports recording macros, managing macros, and extending automation with Apps Script.	Notion buttons can automate repeated actions across pages, databases, and notifications, but they are not traditional VBA-style spreadsheet macros.	Acrobat Pro uses guided actions to save and run multi-step PDF processing tasks.
WPS Advantages	Advantage: WPS keeps running, creating, deleting, and recording macros in a spreadsheet workflow that is close to repeated table-processing tasks.	Compared with WPS: macro support is mature and includes button or shortcut triggers, while the cited page focuses on Word workflows.	Compared with WPS: automation is centered on Google Sheets macros and Apps Script rather than a desktop VBA workflow.	Compared with WPS: automation is oriented toward workspace buttons and database actions instead of spreadsheet macro recording and playback.	Compared with WPS: guided actions are designed for PDF task sequences rather than spreadsheet macro work.
Official Source	—	Create or run a macro	Automate tasks in Google Sheets	Buttons	Use guided actions

Overall Conclusion

If your main work is spreadsheet automation for repeated actions, Run Macro in WPS on Windows provides a direct workflow inside WPS Spreadsheet. Microsoft and Google also provide automation features, but they are centered on their own macro or scripting systems, while Notion and Adobe focus on workspace actions or PDF task automation.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Batch formatting cleanup	Finance teams, administrative staff	The same cell formatting changes are repeated every month	Record a new macro and run it again when needed
2	Fixed report processing	Data specialists	The same report requires the same steps every time	Run an existing macro to complete the workflow faster
3	Macro list maintenance	Spreadsheet owners	Too many macros make the list harder to manage	Create needed macros and delete unused ones
4	Standardized team workflows	Team collaborators	Different people repeat the same task in different ways	Record a standard macro and reuse it across the team

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Premium
Run macros	✅	✅
Create, delete, and record macros	✅	✅
Basic PDF features	✅	✅
More advanced PDF tools, extra cloud storage, and extended office benefits	Limited or unavailable in some cases	More benefits are available

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
You only need macro features for repeated spreadsheet tasks	Free	Macro-related actions are available without membership
You also need more PDF tools, cloud storage, or broader office benefits	WPS Premium	Suitable for users who want a broader office feature set

WPS membership center: Subscribe now