How to Fix a WPS Spreadsheets Macro Button and Find Missing Recorded Macros
Question details
The user needs to fix macro buttons that do not run and locate recorded macros that are missing from the macro list in a macro-enabled spreadsheet.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A user has added or recorded macros in a spreadsheet and needs the macro button or recorded macro list to work consistently.
- Observed behavior
- The macro button does nothing when clicked, and recorded macros do not appear in the macro list after recording or reopening the file.
Before you begin, make sure the workbook is saved in an Excel Macro-Enabled Workbook format such as .xlsm, and note the macro name and storage location you used when recording.
Enable Macros and Reassign the Macro Button
Use this when the macro button exists but does not run, or when you see a security prompt that blocks VBA.
Macro buttons often stop running because macro execution is blocked by Trust Center security settings or because the button is not assigned to the correct macro.
Click File > Options > Trust Center > Trust Center Settings > Macro Settings, then select "Enable VBA macros with notification" or a similarly controlled option.
Right-click the macro button and choose Assign Macro. In the dialog, select the intended macro name and confirm with OK.
Save the file as an Excel Macro-Enabled Workbook (.xlsm), reopen it, and choose Enable Content or Enable Macros when prompted.
Recover Missing Recorded Macros with the Correct Storage Location
Use this when a macro was recorded successfully but does not show up in the macro list after saving or reopening the workbook.
Fix Macro Buttons and Restore Missing Recorded Macros in WPS Spreadsheets
WPS Spreadsheets lets you control macro security, assign macros to buttons, and save macro-enabled workbooks so your existing Excel VBA projects remain usable.
- 1. Open Trust Center in WPS Spreadsheets: Click the Menu button in the top-left corner, choose Options, then open Trust Center > Macro Settings and enable macro prompts.
- 2. Assign the macro to the button: Right-click the macro button, select Assign Macro, choose the correct macro from the list, and confirm.
- 3. Save in a macro-enabled format: Click Menu > Save As and choose Excel Macro-Enabled Workbook (*.xlsm) as the file type.
- 4. Reopen with content enabled: Close and reopen the workbook, then click Enable Content or Enable Macros when the security prompt appears.
- 5. Run the macro: Click the button or run the macro from Developer > Macros to verify it executes successfully.
Frequently Asked Questions
Why does my macro button do nothing when I click it?
Macro buttons usually fail because macro execution is blocked by security settings or the button is not assigned to the correct macro. Open File > Options > Trust Center > Trust Center Settings > Macro Settings, enable notification, then right-click the button and choose Assign Macro.
Where did my recorded macros go after saving the workbook?
If the workbook was saved as a normal .xlsx file, recorded macros are not retained. Save the workbook as an Excel Macro-Enabled Workbook (.xlsm), and when recording, set "Store macro in" to This Workbook or New Workbook.
How do I make WPS Spreadsheets trust my macro file?
Add the workbook folder to the Trust Center trusted locations. Go to File > Options > Trust Center > Trust Center Settings > Trusted Locations, then add the folder that contains the macro-enabled workbook.
Can WPS Office open Excel files that contain VBA macros?
Yes, WPS Spreadsheets can open and save Excel macro-enabled workbooks such as .xlsm files. For the best macro compatibility, use the Windows version of WPS Office and enable macro prompts when opening the file.
Is it safe to enable all macros?
No. Only enable all macros if you fully trust the source of every workbook you open. The safer option is to enable VBA macros with notification, use trusted locations, or rely on digitally signed macros.
