How To Enable "Microsoft has blocked macros from running untrusted source". Add Trusted Locations!

2022/09/06 に公開
視聴回数 90,470
0
0
Hi Everyone, almost every company in this world uses Macros for Office automation. Microsoft Office has rolled out a new update, rolled it back and forth while not thinking this through.
When you open a macro enabled excel file, some of you may see this new message "Security Risk - Microsoft has blocked macros from running because the source of this file is untrusted."

If you download a macro enabled file from email or from the internet and you trust the publisher then simply follow these steps to add a trusted location and it will work for you.

How to Enable Macros and How to unblock a macro enabled xlsm file?
Watch this video to get rid of this pink Security Risk warning Microsoft has blocked macros from running because the source of this file is untrusted.

https://www.ganttexcel.com/blocked-macros-enable-macros-in-microsoft-excel-microsoft-office/