WPS Developer Tools on Windows FAQ

Last updated:July 17, 2026

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?

  1. Open WPS Spreadsheet.
  2. Click the Tools tab at the top.
  3. Click Developer.
  4. 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?

  1. Confirm that you are using a Windows desktop environment.
  2. After clicking VB Editor, check whether a VBA plug-in installation prompt appears.
  3. Complete the installation and open the entry again.
  4. If it still does not work, restart WPS Spreadsheet and try again.

Do regular users need Developer Tools?

  1. If you only edit spreadsheets in routine ways, you can continue using the standard ribbon tools.
  2. If you need to run macros, record actions, manage add-ins, or maintain scripts, Developer Tools is more suitable.
  3. 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?

  1. Only open and run macro files from trusted sources.
  2. Review the Macro Security settings first and confirm the current execution policy.
  3. Back up important data before running macros on important files.
  4. If a macro depends on add-ins or external components, confirm that the local environment is ready.

Glossary

TermDefinition
MacroA set of commands or scripts used to automate repetitive actions.
VBA plug-inA component that supports VB Editor and related VBA functions.
Add-inAn extension component used to expand WPS Spreadsheet functions.
JS environmentThe runtime environment used for JavaScript macro or related development tasks.