VBA & Macro Problems

How to Fix Cannot Enable Macros or Find Unblock Option in Office Files

John Wilson Oct 10, 2026 868 views

Question details

The user is unable to enable macros or locate the Unblock option in the properties of a downloaded or cloud-synchronized macro-enabled Office file.

How to Fix Cannot Enable Macros or Find the Unblock Option in Office Files

Product: Office
Device & OS: Windows
Scenario: Attempting to open and run a macro-enabled file downloaded from the internet or stored in a synchronized cloud folder like OneDrive or Google Drive.
Observed behavior: The Unblock option is missing in the file properties menu, preventing the user from enabling and executing macros within the spreadsheet or document.

Before you start

Ensure the macro-enabled file is from a verified and trusted source before attempting to unblock it, as malicious macros can pose significant security risks to your computer.

Solution 1Recommended

Move the File to a Local Trusted Folder and Unblock

Cloud-synchronized folders can hide the Unblock option in file properties. Moving the file to a local directory typically resolves this issue.

When files are stored in OneDrive, Dropbox, or Google Drive, the operating system may handle file security properties differently, often hiding the Mark-of-the-Web (MOTW) Unblock checkbox. Moving the file to a local drive restores this option.

Copy the synchronized file

Locate the macro-enabled file in your synced cloud folder. Right-click the file and select 'Copy'.

Paste to a local folder

Navigate to a completely local folder on your hard drive, such as your Desktop or Documents folder, right-click inside the folder, and select 'Paste'.

Open file properties

Right-click the newly pasted local file and select 'Properties' from the context menu.

Unblock the file

Under the 'General' tab, look for the 'Security' section at the bottom. Check the 'Unblock' box, then click 'Apply' and 'OK'.

Move the File to a Local Trusted Folder and Unblock

Verified Source: Only unblock files if you are absolutely certain they come from a safe and verified sender.

Solution 2

Add the Folder to Office Trusted Locations

If unblocking the file individually fails, you can add the folder where the file is stored to your Office Trusted Locations to allow macros to run.

Advanced Macro Support

Easily Manage Macros and Secure Files with WPS Office

WPS Office provides a streamlined and secure interface for handling macro-enabled documents. With robust VBA support in professional versions, you can safely run, edit, and manage your macros without complex security blockages.

1. Launch WPS Office: Open WPS Spreadsheet and click on 'Menu' located at the top-left corner, then select 'Options'.
2. Access Macro Security: In the Options window, navigate to 'Security' or 'Trust Center' to view your active protection rules.
3. Adjust Settings: Select 'Macro Security' and choose your preferred level, such as 'Disable all macros with notification', allowing you to safely choose when to run macros on trusted files.

Fully compatible with Microsoft Excel macro formats (.xlsm, .xltm)Clear and intuitive Trust Center to easily manage macro security settingsLightweight application that runs smoothly and securely on WindowsSeamlessly open files from cloud or local storage without hassle

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Unblock option missing in file properties?

The Unblock option typically disappears if the file is stored in a FAT32-formatted drive, inside a cloud-synced folder (like OneDrive or Dropbox), or if the file was created locally and does not carry the Windows 'Mark of the Web' tag.

Are macros safe to enable on my computer?

Macros can contain malicious code that harms your system. You should only enable macros or unblock files if you completely trust the sender and are expecting to receive a macro-enabled file.

What happens if I do not unblock a downloaded macro file?

If you do not unblock the file, modern Windows and Office security features will automatically block the macros from running. You will likely see a red security warning banner at the top of the application indicating that macros have been disabled to protect your computer.

Excel & Data Problems