VBA & Macro Problems

Troubleshoot Excel Macro and Data-Entry Form Problems in WPS Spreadsheet

Camila MilosovichCamila Milosovich Nov 13, 2026 868 views

Question details

The user needs to troubleshoot data-entry form problems involving Excel macros, including unexpected formula behavior and a missing Assign Macro command for form controls or buttons in Excel 2021.

Troubleshoot Excel Macro and Data-Entry Form Problems in WPS Spreadsheet
Product
WPS Spreadsheet
Device & OS
not provided
Scenario
A user is building or maintaining a macro-enabled data-entry form in a spreadsheet and needs formulas, form controls, and VBA macros to work correctly.
Observed behavior
Formulas return unexpected results, and the Assign Macro command is missing when right-clicking a form control or button in Excel 2021.
Before you start

Save a copy of the workbook in Excel Macro-Enabled Workbook (.xlsm) format and confirm that the Developer tab is visible in WPS Spreadsheet so you can inspect formulas, form controls, and macro settings.

Solution 1Recommended

Check formula references, number formats, and protected cells

Use this when a data-entry form returns unexpected formula results or values that do not update correctly.

Many data-entry formula issues are caused by cell reference mistakes, text-formatted numbers, or protection settings rather than broken VBA code.

1
Select the formula cell and review the formula bar

In WPS Spreadsheet, open the workbook and click the formula cell. Check the formula bar for correct cell references, missing parentheses, or references to empty cells.

2
Check number formats and text values

Press Ctrl+1 to open the Format Cells dialog, click the Number tab, and confirm that input cells are not formatted as Text. Also verify that referenced cells contain numeric values instead of text-like numbers.

3
Unprotect the worksheet if needed

Go to the Review tab and click Unprotect Sheet. If the sheet is protected, enter the password, because protection can block edits to locked cells used by the form.

4
Turn on Show Formulas to inspect calculations

Click the Formulas tab and select Show Formulas to display all formulas in cells, then confirm each reference points to the intended input or calculation cell.

Check formula references, number formats, and protected cells
Expected result: The data-entry form formulas display the correct results after cell references, number formats, and protection settings are verified.
WPS Spreadsheet Macro Support

Fix Macro and Data-Entry Form Problems in WPS Spreadsheet

Use WPS Spreadsheet to inspect formula references, enable macro content, and restore the Assign Macro command on Form Control buttons so your Excel-compatible .xlsm data-entry forms work as expected.

  1. 1. Open the workbook: In WPS Spreadsheet, click File > Open and select the macro-enabled .xlsm workbook that contains the data-entry form.
  2. 2. Enable the Developer tab: Go to File > Options > Customize Ribbon, enable Developer, and click OK so form control and macro tools are visible.
  3. 3. Inspect formulas and protection: Select the problem cell, review the formula bar, press Ctrl+1 to check number formats, and use the Review tab to unprotect the sheet if necessary.
  4. 4. Restore the macro command: In the Developer tab, click Insert > Form Controls > Button, draw the button, right-click it, and choose Assign Macro to link the correct VBA procedure.
  5. 5. Save as macro-enabled: Click File > Save As, choose Excel Macro-Enabled Workbook (*.xlsm), and save the file to preserve macros and form controls.
Resolve formula and macro issues in one familiar spreadsheet interfaceOpen, edit, and save Excel .xlsm macro-enabled workbooks with Microsoft Office format compatibilityInsert Form Controls and assign VBA macros without switching applicationsFree, lightweight, and easy-to-use Office alternative for everyday spreadsheet tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why is the Assign Macro command missing when I right-click a control?

The command normally appears only on Form Controls. In WPS Spreadsheet, enable the Developer tab, insert a Form Control button from Developer > Insert > Form Controls > Button, and make sure the workbook is saved as .xlsm with macros enabled.

How do I save a macro-enabled workbook in WPS Spreadsheet?

Click File > Save As, choose Excel Macro-Enabled Workbook (*.xlsm), and save. This preserves VBA macros and form controls for Excel 2021 compatibility.

Why does my data-entry form formula show unexpected results?

Check the formula bar for incorrect references, press Ctrl+1 to verify number formats are not Text, unprotect the sheet from the Review tab if locked, and use Formulas > Show Formulas to inspect calculations.

How do I enable macros in WPS Spreadsheet after opening a file?

Go to File > Options > Trust Center > Trust Center Settings > Macro Settings, select 'Disable all macros with notification', reopen the workbook, and click Enable Content when prompted.

Can I open an Excel 2021 .xlsm data-entry form in WPS Spreadsheet?

Yes. WPS Spreadsheet supports .xlsm files and VBA macros, but test the form after opening because some complex ActiveX or VBA references may require adjustment.