Microsoft Office Tutorials and References
In Depth Information
Displaying the Developer Tab
Figure 22-2: The Macro Settings section of the Trust Center dialog box.
Excel 2010 remembers your decision; if you enable the macros in a workbook, you will
not see the Security Warning the next time you open that file.
Figure 22-3: Excel’s Security Warning that the file contains macros.
If the VBA window is open when you open a workbook that contains macros, Excel
does not display the Security Warning in the workbook. Rather, it displays the dialog
box shown in Figure 22-4. You can use this dialog box to enable or disable the macros.
Perhaps the best way to handle macro security is to designate one or more folders as trusted
locations. All workbooks in a trusted location are opened without a macro warning. You
designate trusted folders in the Trusted Locations section of the Trust Center dialog box.