Macro Settings

The Macro Settings category contains settings that control how Excel responds to workbooks and add-ins that contain macros. These settings do not apply to workbooks or add-ins that have been opened from a trusted location. See the "Trusted Locations" section for more details. Unlike ActiveX Settings, changes to Macro Settings only affect Excel. The settings contained in the Macro Settings category are shown in Figure 22-7.

Trust Center

Trusted Publishers

Macro Settings

Trusted Locations

For macros in documents not in a trusted

location:

Add-ini

0 Disable all macros without notification

ActiveX Settings

0 Disable all macros with notification

1 I

O Disable all macros except digitally signed

Macro "üftlftrjs

macros

O Enable atl macros (not recommended

Message Bar

potentially dangerous code can run)

External Content

Developer Macro Settings

Prrvacv Options

1 1 Trust access to the VBA project object model

OK II Cancel

Figure 22-7

Figure 22-7

The following list describes the settings in the Macro Settings category and explains their effect on workbooks and add-ins that contain macros. Note that changes to these settings will not affect currently open workbooks. You will need to close and reopen any currently open workbook in order for the new settings to take effect.

□ Disable all macros without notification — If this option is selected, all macros in all workbooks and add-ins are disabled without Message Bar notification (see the following "Message Bar" section for more information on the Message Bar). Note that you will still be able to view and edit macros in workbooks opened with this setting selected, but you will not be able to run those macros.

□ Disable all macros with notification—If this option is selected, you will be presented with a security alert dialog, shown in Figure 22-8, each time you open a workbook or add-in that contains macros. Using the security alert dialog, you can choose to enable or disable macros on an individual basis for each file you open. This is the default option for the Macro Settings category.

□ Disable all macros except digitally signed macros — This option operates exactly like the Disable All Macros without Notification option on workbooks containing VBA code that have not been digitally signed. If a workbook containing VBA code has been digitally signed by a trusted publisher, the workbook is opened with macros enabled. If a workbook containing VBA code has been digitally signed but you have not yet trusted the signer, you are presented with a security alert dialog, similar to the one shown in Figure 22-8, that allows you to either enable or disable the VBA code in the signed workbook. For more information on trusted publishers, see the "Trusted Publishers" section.

□ Enable all macros (not recommended, potentially dangerous code can run) — If this option is selected, all macros in all workbooks and add-ins will be enabled and you will not be notified when you open a workbook or add-in that contains VBA code.

□ Trust access to the VBA project object model — Some VBA programs are designed to operate on the VBA project of a workbook or add-in. These programs are usually tools designed for use by VBA programmers. This checkbox must be checked in order for tools of this nature to function. This checkbox is unchecked by default, and VBA code is not allowed to access the VBA project of any workbook or add-in.

Microsoft Office Excel Security Notice 00

Microsoft Office has identified a potential security concern.

Warning: It is not possible to determine that this content came from a trustworthy source. You should leave this content disabled unless the content provides critical functionality and you trust its source.

File Path: C:\Files\Bookl .xlsm

Macros have been disabled. Macros might contain viruses or other security hazards, Do not enable this content unless you trust the source of this file,

More information

[ Enable Macros | [i Disable Macros i|

Figure 22-8

0 0

Post a comment