Appearance
Estimated Time to Fix: 3 minutes
Summary
This article explains what to do when you open a Microsoft Office file and see a yellow bar at the top warning you about "Protected View", "Macros have been disabled", or "SECURITY WARNING".
Symptoms
- You open a document from the internet or an email, and a yellow bar appears at the top saying "Protected View".
- An Excel spreadsheet with automated scripts shows "SECURITY WARNING Macros have been disabled".
- You cannot edit the document or run the automated scripts until the warning is resolved.
Before You Start
- None required.
Instructions
1. Enable Editing (Protected View)
Protected View is Office holding a downloaded file at arm's length until you say it is safe.
- If the yellow bar says PROTECTED VIEW, it means the file was downloaded from the internet or received via email. Office opens it in a restricted mode to prevent viruses from infecting your computer.
- If you trust the sender and expected the file, click the Enable Editing button on the right side of the yellow bar.
- The file will now become editable.
If the yellow bar reads SECURITY WARNING Macros have been disabled instead, Enable Editing does not clear it. Go to Step 2. If the same bar returns every time you reopen the file, the block is attached to the file itself — skip to Step 3.
2. Enable Content (Macros)
Macros are code, so this is the one warning worth reading before you dismiss it.
- If the yellow bar says SECURITY WARNING Macros have been disabled, the file contains automated code (macros).
- Malicious macros are a very common way hackers distribute ransomware. You should only enable macros if you explicitly trust the source (e.g., an internal company report).
- If you trust the file, click the Enable Content button on the right side of the yellow bar. The macros will now run.
3. Unblock a Downloaded File (Persistent Warnings)
When the same warning returns every time, the block is stored on the file itself rather than in Office.
- Sometimes, clicking "Enable Content" doesn't work, or the warning keeps coming back.
- Close the Office application completely.
- Locate the downloaded file in your Downloads folder (or wherever you saved it).
- Right-click the file and select Properties.
- At the bottom of the General tab, look for a "Security" section. Check the box that says Unblock.
- Click OK, then reopen the file. The warnings should disappear.
Troubleshooting
DANGER
Never click "Enable Content" or "Enable Editing" on an invoice, receipt, or tracking document from an unknown sender. This is a common phishing tactic used to install malware on your computer.
| Symptom / Error | Potential Cause | Solution |
|---|---|---|
| "Microsoft has blocked macros from running" | Mark of the Web | Microsoft strictly blocks macros in files from the internet. Use Method 3 to "Unblock" the file via its Properties menu. |
| There is a red warning bar instead of a yellow one | IT Policy | Your IT department has completely blocked the content. You must request an exception from the IT Help Desk. |