Thus, you can know about the enable/disable macros in your worksheet. And here we will explain the difference among those options. In the “Macro Settings” window, there are four options that you could choose. You may choose either of the two methods according to your habit. When you have added the “Developer” tab in the ribbon, using the second method can be quicker. Therefore, you can also open the “Macro Settings” dialog. Then click the button “Macro Security” in the “Code” area.Now click the tab “Developer” in the ribbon.Thus, you have added the tab to the Excel ribbon.
Therefore, today we will talk about how to enable/disable macros in your Excel. The security of macro is a key element for the security of Excel.