![how to disable macros in excel 20007 how to disable macros in excel 20007](https://www.automateexcel.com/excel/wp-content/uploads/2019/03/1-Security-Warning-Bar.png)
Microsoft should hire some industrial engineers specializing in HUMAN Engineering whenĭesigning their menus to make it easy to find the menu choices. If the option to Enable macros was on the main menu it wouldn't be so bad, but to have to go through multiple menu choices to change the option is not resonabble. I like the old option in 2003 much better to be able to be notrified when a macro was in a workbook.
#HOW TO DISABLE MACROS IN EXCEL 20007 CODE#
Then click on the Visual Basic option in the Code group.
![how to disable macros in excel 20007 how to disable macros in excel 20007](https://www.addictivetips.com/app/uploads/2009/12/Office2010TrustCenter.jpg)
Select the Developer tab from the toolbar at the top of the screen. Select the option called ' Show Developer tab in the Ribbon '. Excel 2007 security options select the Enable this content option. When the Excel Options window appears, click on the Popular option on the left. Excel 2007 macro warning click the Options button. Then Enable this content as shown by in figure 4. I would be a secirity risk to allow VBA to change this setting because a virus would be able to change the setting. In Excel 2007, Click Options as shown by in figure 3.
![how to disable macros in excel 20007 how to disable macros in excel 20007](https://jkp-ads.com/images/preventopenevent03.gif)