WPS VB Editor on Windows FAQ

Q: Why did my macro disappear after saving?

Check whether the file was saved as a standard .xlsx workbook. Save the file again as .xlsm . Reopen the file and confirm that the macro code is still there.

When using WPS VB Editor, the most common questions fall into 3 areas: finding the entry, using the shortcut, and saving macro files; this FAQ covers 3 common questions.

FAQ

Why can’t I find the VB Editor entry?

Confirm that you opened WPS Spreadsheets rather than Writer or Presentation.
Check whether the Developer tab is available at the top of the window.
If the entry is still missing, confirm that the VBA plugin has been installed.

Why doesn’t Alt+F11 open the editor?

Click the WPS Spreadsheets window first so the app has focus.
Press Alt+F11 again.
If your device uses a function-key combination, try the matching keys for your keyboard layout.

Why did my macro disappear after saving?

Check whether the file was saved as a standard .xlsx workbook.
Save the file again as .xlsm.
Reopen the file and confirm that the macro code is still there.

Glossary

Term	Definition
VB Editor	The editing interface used to view and edit VBA macro code.
VBA	Short for Visual Basic for Applications, a scripting language used to automate tasks in office documents.
`.xlsm`	A workbook format that supports saving macro code.