Security Policy Errors

Fix WPS Spreadsheets Macro Blocked from Untrusted Files

Ayan MasoodAyan Masood Nov 13, 2026 871 views

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.

Fix WPS Spreadsheets Macro Blocked from Untrusted Files
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.
Before you start

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.

Solution 1Recommended

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.

1
Open file properties

In File Explorer, right-click the macro-enabled workbook and choose Properties.

2
Unblock the file

On the General tab, find the Security section and check the Unblock option.

3
Apply the change

Click Apply and then OK to save the file property change.

4
Reopen in WPS Spreadsheets

Open the file in WPS Spreadsheets and click Enable Macros if the security warning appears.

Unblock the File in Windows File Properties
Unblock option missing: If the Unblock check box is not shown, the file is not marked as blocked. Move to macro security settings or add the workbook to a trusted location instead.
WPS Spreadsheets macro security

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. 1. Open WPS Spreadsheets: Open WPS Office and launch WPS Spreadsheets from the home screen.
  2. 2. Open macro security settings: Click the Menu button, then choose Options > Security > Macro Security.
  3. 3. Set the macro security level: Set macro security to Medium to receive a prompt before macros run, then click OK.
  4. 4. Unblock the workbook: In File Explorer, right-click the blocked workbook, choose Properties, check Unblock, and click OK.
  5. 5. Enable macros and run: Reopen the workbook in WPS Spreadsheets and click Enable Macros when prompted.
Built-in macro security settings to approve or block VBA code from untrusted filesOpens Excel .xlsm, .xlsx, and .xls files with strong Microsoft Office format compatibilityFree, lightweight Office suite with a familiar spreadsheet interfaceLets you safely manage macro-enabled workbooks without replacing your workflow
microsoft office alternative - wps office

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.