Excel 2007 macro security group policy

Written by james dalton
  • Share
  • Tweet
  • Share
  • Pin
  • Email
Excel 2007 macro security group policy
Group Policies can control macro security in Microsoft Excel 2007. (number background image by kuhar from Fotolia.com)

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

Methods

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.

Settings

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."

Warnings

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.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.