Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

Because of Your Security Settings Macros Have Been Disabled

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.


Download Practice Workbook

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


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: [Fixed!]: Unable to Enable Macros in Excel (5 Quick Solutions)


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!] Macros Not Working in Excel (3 Possible Solutions)


Similar Readings


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: [Fixed] Excel Macros Enabled But Not Working


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: [Solved]: Macro Settings Greyed out in Excel


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.

For more information like this, visit Exceldemy.com.


Related Articles

Tags:

Mehedi Hasan

Mehedi Hasan

Hi, I am Mehedi. I have completed my B.Sc. from Bangladesh University of Engineering and Technology. I have a strong interest in innovation and research in the field of Data Science and Machine Learning. Gradually, I now understand the value of Data Analysis and I am trying to learn everyday.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo