Run Macro in WPS on macOS: Introduction

Run Macro in WPS on macOS helps you run, create, delete, and record WPS 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
Platform scope	macOS	This page focuses on WPS Spreadsheet on Mac

About This Feature

Overview

Run Macro in WPS Spreadsheet on macOS is an automation feature for handling repeated spreadsheet actions. It lets you run an existing macro, create a new macro entry, delete a macro you no longer need, and record a new macro for repeated use.

This feature is useful when you want to reduce repeated manual steps in spreadsheet work. Common tasks include reusing saved macro flows, organizing macro entries, and recording a repeatable operation for later execution.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office for macOS normally
App version	It is recommended to use the latest version of WPS Office for Mac
Network	No mandatory network connection is typically required for local macro actions; downloading, installation, and account-related actions require internet access
Other	Open a workbook in WPS Spreadsheet and make sure the Developer entry is available

Download & Installation

Install WPS Office for Mac before using Run Macro, then open WPS Spreadsheet and confirm that the Developer tab is available.

Item	Details
Official download	WPS Office Free Download
Post-install check	Launch WPS Spreadsheet, open a workbook, and confirm that you can access the Developer tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports running existing macros, creating macros, deleting macros, and recording new WPS macros on macOS.	Microsoft Word supports recording macros, running them from a button or keyboard shortcut, and storing them in templates for later use.	The official Google Docs page highlights Gemini writing and summarization features, but it does not describe a local spreadsheet-style macro recording and running workflow.	Notion Buttons can automate multi-step actions such as inserting content, editing pages, sending notifications, or opening a page.	Adobe Acrobat Pro guided actions combine multiple commands into a single workflow and can process one or more files in batches.
WPS Advantages	Advantage: WPS keeps run, create, delete, and record actions in a direct spreadsheet workflow on macOS.	Compared with WPS: the official guidance covers recording and running macros, but the example focuses on Word document workflows rather than spreadsheet macro tasks.	Compared with WPS: the official page focuses on AI-assisted writing instead of spreadsheet macro recording for repeated operations.	Compared with WPS: automation is centered on pages and databases rather than spreadsheet macro recording and execution.	Compared with WPS: guided actions are designed for PDF batch processing rather than spreadsheet macro recording.
Official Source	—	Create or run a macro	Gemini in Google Docs	Buttons	Use guided actions (Acrobat Pro)

Overall Conclusion: If your main goal is to automate repeated spreadsheet actions inside WPS on macOS, Run Macro provides a direct in-app workflow. Other products also offer automation, but their official focus is different, including document macros, AI writing assistance, page automation, or PDF batch actions.

Use Cases

No.	Scenario	Suitable for	Main pain point	How Run Macro helps
1	Repeating fixed spreadsheet steps	Users who handle recurring spreadsheet tasks	The same actions must be repeated manually	Run a saved macro directly from the macro list
2	Organizing personal automation entries	Users who maintain multiple macros	Macro entries become harder to manage over time	Create a new macro entry for later use
3	Cleaning up old macro items	Users maintaining long-term workbooks	Unused macros make the list harder to review	Delete macros that are no longer needed
4	Recording a repeatable workflow	Users who want to save manual steps for reuse	Repeated actions take time and are easy to miss	Record a new macro and reuse it later

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Run Macro related entry points	Available as described for this feature	Available as described for this feature
Basic PDF features	Included	More complete PDF tool access
Cloud storage	1 GB	20 GB
Template downloads	Limited	More template benefits

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
You mainly use Run Macro for daily spreadsheet repetition	Free	This feature is described without a membership restriction, so you can start with the free plan
You also need broader PDF tools, more cloud storage, or more template benefits	WPS Premium	A better fit for users with broader office workflow needs

Visit the subscription page: Subscribe to WPS Premium
Review the available plans and choose the one that fits your workflow.