WPS Macro Editor on macOS FAQ

When using WPS Macro Editor, common questions usually involve where to find the entry, how to use the shortcut, how to save macro-enabled files, and what macro type is supported; this section includes 4 common questions and 4 glossary terms.

FAQ

Why does the file format say macros are not supported when I save?

1. Check whether the current file format is .xlsx.
2. If it is a standard workbook format, choose Save As again.
3. Change the file format to .xlsm and save the file.
4. Reopen the file and confirm that the macro content is still available.

Does macOS support VBA macros in this editor?

1. Before using the macro feature, confirm which macro type you are working with.
2. Macro Editor is used for WPS macros in JavaScript format.
3. If your script logic is written for VBA, evaluate whether it needs to be rewritten as a WPS macro.
4. On this platform, continue with the JavaScript macro workflow.

What should I do if I cannot find the WPS Macro Editor button?

1. Confirm that you opened WPS Spreadsheet rather than another WPS app.
2. Check whether you are in the spreadsheet editing interface.
3. Try pressing option + Fn + F11 to open the editor directly.
4. If the entry still does not appear, update to a newer version of WPS Office for Mac and check again.

What is the fastest way to open Macro Editor?

1. Open the target spreadsheet file.
2. Press option + Fn + F11 directly.
3. If your keyboard settings affect function key input, adjust them and try again.
4. You can also keep the Developer tab entry as a backup way to open the editor.

Glossary