Microsoft Office Tutorials and References
In Depth Information
Understanding Security Issues Related to Macros
Understanding Security Issues Related to Macros
Recent versions of Excel have made macro security a key priority. The reason is that macros are
powerful — so powerful that they can do serious damage to your computer and even to other
computers on your network. Unfortunately, lots of people in the world find it entertaining to see
how much harm they can accomplish from their computer desks.
Security settings are specified in the Trust Center dialog box. Figure 212-1 shows the Macro
Settings section of the Trust Center dialog box. To display this dialog box, follow these steps:
1. Choose File
Options.
2. In the Excel Options dialog box, click the Trust Center tab.
3. Click the Trust Center Settings button.
4. Click the Macro Settings tab.
Figure 212-1: The Macro Settings section of the Trust Center dialog box.
By default, Excel uses the Disable All Macros with Notification option. With this setting in effect,
if you open a workbook that contains macros (and the file isn’t digitally “signed” or in a trusted
location), the macros are disabled, and Excel displays a security alert above the Formula bar. If
you’re certain that the workbook comes from a trusted source, click Enable Content to enable
the macros.
 
Search JabSto ::




Custom Search