Common questions about WPS Developer Tools usually focus on tab visibility, the VBA plug-in, macro security, and add-in management; this page includes 4 common answers and 4 glossary terms.
FAQ
What should I do if I cannot find the Developer tab?
- Open WPS Spreadsheet.
- Click the Tools tab at the top.
- Click Developer.
- Return to the top ribbon and confirm whether the Developer tab is now visible.
Why can I not use VB Editor right away after clicking it?
- Confirm that you are using a Windows desktop environment.
- After clicking VB Editor, check whether a VBA plug-in installation prompt appears.
- Complete the installation and open the entry again.
- If it still does not work, restart WPS Spreadsheet and try again.
Do regular users need Developer Tools?
- If you only edit spreadsheets in routine ways, you can continue using the standard ribbon tools.
- If you need to run macros, record actions, manage add-ins, or maintain scripts, Developer Tools is more suitable.
- You can start with Run Macro or Record New Macro and then explore the other entries gradually.
What should I pay attention to before running macros?
- Only open and run macro files from trusted sources.
- Review the Macro Security settings first and confirm the current execution policy.
- Back up important data before running macros on important files.
- If a macro depends on add-ins or external components, confirm that the local environment is ready.
Glossary
| Term | Definition |
|---|---|
| Macro | A set of commands or scripts used to automate repetitive actions. |
| VBA plug-in | A component that supports VB Editor and related VBA functions. |
| Add-in | An extension component used to expand WPS Spreadsheet functions. |
| JS environment | The runtime environment used for JavaScript macro or related development tasks. |