How to Use WPS Macro Editor on macOS

Use WPS Macro Editor with 4 how-to topics on macOS; all 4 are available without membership and 0 are membership-related, so you can jump from the index to the steps you need.

How-to Index

How-to Guide

1. Open WPS Macro Editor

Entry: Developer tab → WPS Macro Editor

1. Open a WPS Spreadsheet file on your Mac.
2. Click the Developer tab at the top.
3. Click WPS Macro Editor.
4. Wait for the Macro Editor window to open.

Success Criteria

• Interface result: The Macro Editor window opens.
• What you can do next: You can view or edit the current macro code.

Tips While Using

• If you do not see the Developer-related entry, first confirm that you are in WPS Spreadsheet.
• On macOS, this feature supports WPS macros in JavaScript format.

2. Open Macro Editor with a keyboard shortcut

Entry: Keyboard shortcut

1. Open the WPS Spreadsheet file you want to work with.
2. Press option + Fn + F11.
3. Wait for Macro Editor to open.

Success Criteria

• Interface result: The Macro Editor window opens directly or comes to the front.
• What you can do next: You can continue reviewing or editing macro code.

Tips While Using

• If the shortcut does not work, check your keyboard function key settings and try again.
• You can also open the editor from the Developer tab.

3. View and edit macro source code

Entry: Open WPS Macro Editor

1. Open WPS Macro Editor by using one of the methods above.
2. Locate the macro code you want to review in the editor.
3. Read or modify the JavaScript macro code.
4. Save your changes by using the save option available in the editor.

Success Criteria

• Interface result: The code is visible and editable.
• What you can do next: You can continue debugging, saving, or return to the workbook.

Tips While Using

• Before changing code, confirm what the original logic is used for so you do not affect an existing automation flow.
• On macOS, this feature supports WPS macros in JavaScript format rather than VBA editing.

4. Save a macro-enabled file as .xlsm

Entry: Save or Save As

1. After editing the macro code, click Save or Save As.
2. In the file format options, choose a macro-enabled workbook format.
3. Save the file as .xlsm.
4. Reopen the file and confirm that the macro content is still available.

Success Criteria

• Interface result: The file is saved successfully in .xlsm format.
• What you can do next: You can reopen the file and still access the macro content.

Tips While Using

• A standard .xlsx file does not keep macro code.
• If you see a format compatibility warning, select .xlsm again before saving.