Excel 2008 includes specific settings that help you control how users are notified of potentially unsafe macros. You cannot enable or disable macros or prevent encrypted macros from being scanned for viruses. You can only set notification options that will warn users about macros.
After you configure notification options for macros in preferences, you can deploy the settings to user computers. However, you should warn users about the risks associated with changing any default security settings because their changes may override the settings that you have specified.
Configure security settings for macros
You can use the following procedure to configure the default security setting for macros.
On the Excel menu, click Preferences.
Under Sharing and Privacy, click Security, and then select the Warn before opening a file that contains macros check box.



