How to Use WPS Developer Tools on Windows

Use WPS Developer Tools with 4 how-to topics, including showing the Developer tab, reviewing the main entries, opening VB Editor and checking macro security, and managing add-ins while switching to the JS environment; 4 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Show the Developer tab

Entry: Tools → Developer button → Developer tab

1. Open WPS Spreadsheet.
2. Click the Tools tab at the top.
3. Click Developer.
4. Check whether the Developer tab appears in the top ribbon.

Success Criteria

• Interface result: The Developer tab appears in the top ribbon.
• What you can do next: You can continue to access Run Macro, Record New Macro, VB Editor, and related entries.

Tips While Using

• Common mistake: If you are not in WPS Spreadsheet, the related entry may not appear.
• Environment note: In a narrow window layout, some buttons may be folded into more menus.

2. Review the main Developer entries

Entry: Developer tab

1. First show the Developer tab by following the previous section.
2. Click the Developer tab.
3. Review entries such as Run Macro, Record New Macro, Macro Security, and VB Editor.
4. Locate Add-ins, COM Add-ins, WPS Add-ins, and Switch to JS Environment as needed.

Success Criteria

• Interface result: The main feature buttons are visible on the Developer tab.
• What you can do next: You can open macro, editor, or add-in management functions as needed.

Tips While Using

• Common mistake: If the Developer tab has not been shown first, these entries cannot be reviewed directly.

3. Open VB Editor and check macro security

Entry: Developer → VB Editor / Macro Security

1. Click the Developer tab.
2. Click VB Editor.
3. If a prompt asks you to install the VBA plug-in, complete that installation first.
4. Return to the Developer tab and click Macro Security to review the current macro execution policy.

Success Criteria

• Interface result: The VB Editor window opens, or a VBA plug-in installation prompt appears; the Macro Security settings page can also be opened.
• What you can do next: You can continue to review or edit macro code, or adjust macro-related settings.

Tips While Using

• Common mistake: Without the VBA plug-in, VB Editor related functions may not open directly.
• Environment note: Before running macros, confirm that the file source is trusted.

4. Manage add-ins and switch to the JS environment

Entry: Developer → Add-ins / COM Add-ins / WPS Add-ins / Switch to JS Environment

1. Click the Developer tab.
2. Click Add-ins if you want to review external plugin management.
3. Click COM Add-ins or WPS Add-ins if you need to manage extension components.
4. Click Switch to JS Environment if you want to move to the JavaScript macro development environment.

Success Criteria

• Interface result: The related add-in management page opens, or the environment switch is triggered.
• What you can do next: You can continue to enable or manage extensions, or proceed with development tasks in the JS environment.

Tips While Using

• Common mistake: Different add-in entries serve different extension types, so confirm the target type before selecting one.
• Environment note: Some extensions or environment switches may depend on locally installed components and current settings.