Macros are a feature of Microsoft Excel 2007 that automate routine tasks. A Group Policy is a feature of Microsoft Active Directory that allows you to control the settings for large groups of computers. You can control macro security through a Group Policy.
Other People Are Reading
The Group Policy settings for Microsoft Excel 2007 are contained in the Excel 2007 Administrative Template. Load this into the Group Policy Object Editor, which is a Microsoft Management Console snap-in. You can change settings at the "Site," "Domain" or "Organization Unit" (OU) level.
The settings to control the macro security level in Excel 2007 are located in the "User Configuration\Administrative Templates\Microsoft Office Excel 2007\Excel Options\Security" folder, which is available once the administrative template is loaded. There are two primary settings: the first is "Suppress High Security macro alert for unsigned Macros"; the second is "VBA Macro Warning Settings."
Try out macro security setting changes in a test environment before applying them to a production environment. Macros are a potential security threat, but they are also a useful feature of Excel. Carefully assess any changes to the default macro security levels to ensure that the settings provide an appropriate balance of security and functionality, based on your needs.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for