How to Use WPS VB Editor on Windows

Last updated:July 17, 2026

Use WPS VB Editor with 3 how-to topics, including opening the editor, opening it with a shortcut, and saving a macro-enabled workbook; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership Requirement
11. Open VB EditorFree
22. Open VB Editor with a keyboard shortcutFree
33. Save a macro-enabled workbookFree

How-to Guide

1. Open VB Editor

Entry: Developer → VB Editor

  1. Open WPS Spreadsheets and go to the workbook you want to work with.
  2. Click the Developer tab at the top of the window.
  3. Click VB Editor.
  4. Wait for the editor window to open, then view or edit your macro code.

Success Criteria

  • Interface result: The VB Editor window opens.
  • What you can do next: You can inspect modules, review the project structure, or enter VBA code.

Tips While Using

  • Common mistake: If the Developer entry is missing, confirm that you are using WPS Spreadsheets and that the VBA plugin is installed.
  • Environment note: This feature requires the VBA plugin environment first.

2. Open VB Editor with a keyboard shortcut

Entry: Keyboard shortcut

  1. Open WPS Spreadsheets and keep the target workbook active.
  2. Press Alt+F11.
  3. If your keyboard layout is different, use the matching function-key combination on your device.
  4. Continue viewing or editing code in the editor window.

Success Criteria

  • Interface result: The VB Editor opens directly.
  • What you can do next: You can enter the macro code environment without going through the menu.

Tips While Using

  • Common mistake: If the shortcut does not respond, click the WPS Spreadsheets window first so it has focus.
  • Environment note: Some keyboards may require a function-key combination.

3. Save a macro-enabled workbook

Entry: File → Save As

  1. After editing macro code, return to the workbook window.
  2. Click File and choose Save As or the related save command.
  3. In the file type list, select the macro-enabled workbook format .xlsm.
  4. Confirm the save location and finish saving.

Success Criteria

  • Interface result: The file is saved successfully in .xlsm format.
  • What you can do next: When you reopen the file, the macro code remains available.

Tips While Using

  • Common mistake: If you save the file as .xlsx, macro code will not be kept.
  • Environment note: Before sharing the file, confirm that the recipient also has a macro-ready environment if needed.