
When you try to open and work on a Microsoft Office Excel Sheet on your Windows/Mac device and you see the error "Microsoft has blocked macros from running because the source of this file is untrusted." well this be because
If an Excel (xlsx or xls) or other office files you download from the internet that has VBA macros in them, there is a potential that it may contain a malicious script that can gain access to your device and deploy malware and ransomware. Thus Microsoft has changed the default behavior of Office applications to block macros in files from the internet.
How to unblock files with VBA Macros
- Open the file in Office App (Excel/Word/PowerPoint)
- Now go to General tab -> Properties.
- Now select the Unblock checkbox.
Note: You can also make use of the PowerShell CMDLet Unblock-File
Example:
PS Unblock-File -Path C:\Users\Code2care\Documents\Downloads\ExcelSpreadSheet.xlsx
Provide Feedback For This Article
We take your feedback seriously and use it to improve our content. Thank you for helping us serve you better!
😊 Thanks for your time, your feedback has been registered!
Comments & Discussion
Facing issues? Have questions? Post them here! We're happy to help!