Fix WPS Spreadsheets Macro Blocked from Untrusted Files
Question details
The user needs to run VBA macros in a WPS Spreadsheets workbook that was downloaded from the internet or received by email but is blocked as coming from an untrusted source.

- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user received or downloaded a macro-enabled Excel workbook and wants to open it in WPS Spreadsheets with macros enabled.
- Observed behavior
- WPS Spreadsheets blocks the macros as untrusted, and simply enabling macros does not override the security restriction.
Verify that the file is from a known sender and scan it with your antivirus before changing macro security settings. In WPS Spreadsheets, note the current macro security level under Menu > Options > Security so you can restore it later.
Unblock the File in Windows File Properties
Use this when a downloaded .xlsm file is marked as coming from the internet and WPS Spreadsheets refuses to run its macros.
Windows can mark files downloaded from websites or received through email as blocked. Unblocking the file removes that marker and allows trusted applications such as WPS Spreadsheets to run the VBA project.
In File Explorer, right-click the macro-enabled workbook and choose Properties.
On the General tab, find the Security section and check the Unblock option.
Click Apply and then OK to save the file property change.
Open the file in WPS Spreadsheets and click Enable Macros if the security warning appears.

Move the Workbook to a Trusted Location in WPS Spreadsheets
Use this when you frequently work with macros from a known folder and want to avoid repeated unblocking.
Change Macro Security Settings in WPS Spreadsheets
Use this only after you have verified that the workbook is safe and you need to allow VBA macros to run.
Run Trusted Macros in WPS Spreadsheets After Unblocking the File
WPS Spreadsheets lets you control macro security and run VBA macros from downloaded workbooks after you unblock the file or approve the source. Use WPS Office to open .xlsm files with a familiar spreadsheet interface and built-in security controls.
- 1. Open WPS Spreadsheets: Open WPS Office and launch WPS Spreadsheets from the home screen.
- 2. Open macro security settings: Click the Menu button, then choose Options > Security > Macro Security.
- 3. Set the macro security level: Set macro security to Medium to receive a prompt before macros run, then click OK.
- 4. Unblock the workbook: In File Explorer, right-click the blocked workbook, choose Properties, check Unblock, and click OK.
- 5. Enable macros and run: Reopen the workbook in WPS Spreadsheets and click Enable Macros when prompted.

Frequently Asked Questions
Why does WPS Spreadsheets block macros in files from the internet?
It follows Office security policy that treats files downloaded from websites or received through email as untrusted. This prevents unsigned VBA macros from running automatically until you unblock the file or approve the source.
How do I unblock a macro-enabled workbook in Windows?
Right-click the file in File Explorer, select Properties, and on the General tab check the Unblock option under Security. Click Apply and OK, then reopen the file in WPS Spreadsheets.
Can I allow macros for only one workbook instead of changing global security?
Yes. For a one-off file, unblock it in Windows Properties first. If WPS Spreadsheets still shows a security warning, use Enable Macros only after you have confirmed the file is safe.
Where are macro security settings in WPS Spreadsheets?
Open WPS Spreadsheets, click the Menu button in the top-left corner, and go to Options > Security > Macro Security. There you can choose the security level and trusted locations.
Does WPS Office support Excel macro-enabled files?
WPS Spreadsheets opens and works with .xlsm, .xlsx, and .xls files, and it includes macro security controls to manage VBA macros from untrusted sources.




