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.
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.
- 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.
- 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.
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.
- 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.
- However, you can also select Advanced Options to enable macros for a single session.
- Now, check Enable content for this session and press OK.
- 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
- How to Fix Compile Error in Hidden Module in Excel
- [Fixed!] Invalid Forward Reference in VBA
- [Fixed!] Unable to Set the Visible Property of the Worksheet Class
- [Fixed!] Method Open of Object Workbooks Failed
- [Solved]: User Defined Type Not Defined in Excel VBA
- Sub or Function Not Defined in Excel VBA
- [Solved!] Excel VBA “Argument Not Optional” Error