This FAQ covers 3 common questions about editor type, file saving, and script usage when you use WPS Macro Editor on macOS.
FAQ
Can I switch to the VBA editor in WPS for Mac?
- When you open the Macro Editor on macOS, the available editor is the JS editor.
- If you already have VBA macro code, rewrite the script logic in JavaScript.
- Continue editing and testing the script in the current JS editor.
Why can’t my macro code be saved?
- Check whether the current file is saved in a macro-enabled format.
- If it is a WPS Docs file, save it as
.docm. - Avoid continuing with formats such as
.docx, which do not save macro code.
What should I pay attention to when using macro scripts?
- First confirm that the file format supports macros.
- Only run macro scripts that you wrote yourself or that come from a trusted source.
- Before changing a formal document, test the script on a copy first.
Glossary
| Term | Definition |
|---|---|
| Macro Editor | A code editing interface used to create, edit, and manage macro scripts. |
| JavaScript macro | An automation script written in JavaScript to perform repetitive operations. |
| Macro-enabled file | A file format that can store macro code, such as .docm, .wpm, .xlsm, or .et. |