When using Run Macro, common questions usually involve execution issues, finding the entry point, and security checks; this FAQ includes 3 common questions and a glossary.
FAQ
What should I do if a macro cannot run?
- Open the Developer Tools tab.
- Check whether Macro Security settings are restricting the current macro.
- After confirming that the macro source is trusted, try running it again.
Why can’t I run a VBA macro on Mac?
- Confirm whether your current platform is Mac.
- Note that VBA macro code is supported only on Windows.
- If you need to run a VBA macro, switch to WPS Office on Windows.
What should I check before running a macro?
- Confirm that the macro file or script comes from a trusted source.
- Avoid running macros from unknown sources directly.
- Before using a macro in an important document, test it in a copy first.
Glossary
| Term | Definition |
|---|---|
| Macro | An automation command that packages a set of preset actions so they can be repeated. |
| JS Macro | A macro automation capability based on JavaScript-related scripting logic. |
| VBA Macro | A macro written with Visual Basic for Applications, commonly used for desktop office automation. |