Because of Your Security Settings Macros Have Been Disabled

Get FREE Advanced Excel Exercises with Solutions!

In general, Excel is the most widely used tool for dealing with massive datasets. Moreover, we can perform myriad tasks with multiple dimensions in Excel. In addition to that, Visual Basic for Applications (VBA) is a very useful tool in Excel. However, sometimes we find problems enabling macros in Excel, or it may show some security risks. In this article, I will explain 4 suitable solutions to enable Macros for the “because of your security settings, macros have been disabled” warning in Excel. Hence, go through it carefully and learn more.


4 Quick Fixes for Security Warning of Macros Have Been Disabled

In Microsoft Excel, macros can perform all the activities that a function can do. Sometimes, it performs better when working with numerous data points. Actually, it assists in working with data in various locations. This will make our work easier. In this part, I will show you 4 easy fixes for Excel to solve security warnings for disabled macros. For the purpose of demonstration, I have used the following sample dataset.

Because of Your Security Settings Macros Have Been Disabled Dataset


Solution 1: Solve Through Context Menu

Fortunately, you can solve security warnings of macros in Excel easily by utilizing the context menu from the file explorer. The process is quite simple and easy to operate. However, you have to follow the steps mentioned below in order to properly complete the operation.

📌  Steps:

  • Firstly, open Windows File Explorer and move to the folder where you have saved the desired file.

  • Secondly, right-click on the file and, from the context menu, select Properties.

Solve Because of Your Security Settings Macros Have Been Disabled Warning Through Context Menu

  • Thirdly, click on the Unblock checkbox from the General tab.
  • Fourthly, press OK.

  • Finally, you will find that the security warning problem is resolved, and no further security or risk warnings will appear for the file.

Read More: VBA Object Variable or with Block Variable Not Set in Excel


Solution 2: Activate Macros from Security Warning Bar

In addition to this, you can activate macros directly. However, the simplest way to enable the Macros is to activate them from the security warning bar. This will enable the macros instantly. Hence, follow the steps.

📌  Steps:

  • Initially, select Enable Content.

Activate Macros from Security Warning Bar

  • Finally, Excel will enable the Macros.

Read More: [Fixed!] Subscript Out of Range Error in Excel VBA


Solution 3: Go to Trust Center to Enable Macros

Furthermore, you can utilize the trust center in order to enable macros. Sometimes, Excel may show some security risks, and you can not run the macro without enabling it. However, you can go through the steps below.

📌  Steps:

  • First of all, go to the File tab.

  • Then, go to the Options.

  • Next, select Trust Center and go to Trust Center Settings.

Because of Your Security Settings Macros Have Been Disabled

Note:

In addition, you can add Trusted Locations and Trusted Documents. As a result, macros will be enabled automatically for those particular locations and specific documents.

  • After that, Enable VBA macros from Macro Settings.

Go to Trust Center to Enable Macros

  • Lastly, Excel will activate the macro.

Read More: Reasons And Solutions for Excel Object Required Error in VBA


Solution 4: Allow Macros from File Info

Last but not least, you can allow macros from the file info. However, you can allow macros for a single session or permanently. The process is also simple and easy to operate. Hence, read through the following steps in order to complete the operation.

📌  Steps:

  • Firstly, move to the File tab.

  • Secondly, select the Info option and select Enable Content.

Allow Macros from File Info

  • However, you can also select Advanced Options to enable macros for a single session.

  • Now, check Enable content for this session and press OK.

Because of Your Security Settings Macros Have Been Disabled

  • In the end, the Excel file will enable the macro.

Read More: [Fixed!] Excel Application-Defined or Object-Defined Error in VBA


Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.


Conclusion

These are all the steps you can follow to solve the “because of your security settings macros have been disabled” warning in Excel. Overall, in terms of working with time, we need this for various purposes. I have shown multiple methods with their respective examples, but there can be many other iterations depending on numerous situations. Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.


Related Articles

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Mehedi Hasan
Mehedi Hasan

Mehedi Hasan, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a profound passion for research and innovation, he actively engages with Excel. In his capacity, Mehedi not only adeptly tackles intricate challenges but also showcases enthusiasm and expertise in navigating tough situations with finesse, underscoring his unwavering dedication to consistently delivering exceptional and high-quality content. He... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo