And then choose the option “Customize the Ribbon” in the pop-up menu.Right click any of a tab in the ribbon.If you have already added the tab, you can go to step 5 directly. There are four options that you could choose from.īefore you use this method, you need to add the “Developer” tab in the ribbon. Thus, you can see all the settings in the window. And then in this “Trust Center” window, choose the option “Macro Settings”.After that, click the button “Trust Center Settings”.Next in the “Excel Options” window, click the last option “Trust Center”.Below are the steps about those two different methods. And in Excel, there are two methods to do this. Open the Macro Settings Dialogīefore you modify the settings, you need to open the macro settings window. Hence, correctly enabling/disabling macros macro is rather important. If you run those macros unintentionally, your Excel could be damaged. However, there will also be dangers in some macro-enabled workbooks. Macro is very effective in dealing with complex tasks. 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.
0 Comments
Leave a Reply. |