Once done, the above steps would enable all macros in all the files. Using the Yellow Security Warning BarĪs soon as you open a file that has a macro, you would see a yellow warning bar as shown below. If you have got a file from a trusted source and you want to enable all the macros in the file, you can do this using two methods.īoth of these methods will enable the macros permanently for the given file, which means that the next time you open it, you be asked to enable the macros again.

Enable All Macros in a Specific File (Permanently) Let’s get into each of these scenarios now. You can choose to enable the macro for one-time use only, permanently enable all macros in a specific file, or specify a trusted location and all the files in that folder would have the macros enabled by default. Now, let me show you some methods you can use to enable macros in Excel. So even if you find it irritating and a waste of time to enable macros always, this is a necessary evil. So every time you try to open a file that has a macro (no matter how big or small), Excel will show you a warning (a yellow bar) and you will have to enable the macros yourself. To avoid any issue that can be caused because of a macro, Excel has a default setting to keep macros disabled.Īs the user, the onus is on you to make sure that there is nothing wrong with the file that you’re trying to open. To give you an example, it’s possible for anyone to create a macro that, if enabled, can add malware in your system, or delete some files/folders that are important for you. There is a possibility that there could be malware or a damaging macro in the workbook. If you get a file from someone or you download it from the web, you shouldn’t just go ahead and enable macros on these files. Macros are amazing, they are a huge time saver, but they can also be dangerous (not always, but sometimes). Enable Macros in Files in a Specific Location/Folderīefore Enabling Macros – A Word of Caution!.Enable All Macros in All the Excel Files.Enable Macros in a Workbook for One Time Use (Temporarily).Enable All Macros in a Specific File (Permanently).Before Enabling Macros – A Word of Caution!.

How to disable macros in excel 2010