none
GPO to enable Excel 2007 and 2010 Macro's RRS feed

  • Question

  • Hi,

    Have the need to set our machines to ENABLE Excel Macro's.

    Under User Config, Admin Templates, Microsoft Excel 2010, Excel Options, Security, Trust Center, Trusted Locations, and only see Allow Trusted Locations on the Network.  Disabled that yet when I log onto a workstation after a gpupdate /force Excel still states "Disable all macros with notification" instead of "Enable all Macros"

    Is there an option to Enable Macros via GPO for both 2007 and 2010?

    Thank you

    Tuesday, October 11, 2011 10:53 PM

Answers

  • It sounds like your doing everything right. I just tested with mine and its works as it should. It is enabled and greyed out. Try creating another gpo for anything and see if it shows up.  Maybe you did not wait long enough for your test OU to replicate.


    Regards, ~P MCSE, MCITP, MCTS, MCP, CCNA
    • Edited by Gandalf50 Thursday, October 13, 2011 9:57 PM
    • Marked as answer by Yan Li_Moderator Monday, October 17, 2011 1:01 AM
    Thursday, October 13, 2011 9:57 PM

All replies

  • Go to User Config, Admin Templates, Microsoft Excel 2010, Excel Options, Security, Trust Center

    Look for VBA Macro Notification Settings

    For Excel 2007 look for VBA Macro Warning Settings

    Explanation for 2010

    This policy setting controls how the specified applications warn users when Visual Basic for Applications (VBA) macros are present.

    If you enable this policy setting, you can choose from four options for determining how the specified applications will warn the user about macros:

    - Disable all with notification: The application displays the Trust Bar for all macros, whether signed or unsigned. This option enforces the default configuration in Office.

    - Disable all except digitally signed macros: The application displays the Trust Bar for digitally signed macros, allowing users to enable them or leave them disabled. Any unsigned macros are disabled, and users are not notified.

    - Disable all without notification: The application disables all macros, whether signed or unsigned, and does not notify users.

    - Enable all macros (not recommended): All macros are enabled, whether signed or unsigned. This option can significantly reduce security by allowing dangerous code to run undetected.

    If you disable this policy setting, the "Trust Bar warning for all macros" will be the default setting.

    If you do not configure this policy setting, when users open files in the specified applications that contain VBA macros, the applications open the files with the macros disabled and display the Trust Bar with a warning that macros are present and have been disabled. Users can inspect and edit the files if appropriate, but cannot use any disabled functionality until they enable it by clicking "Enable Content" on the Trust Bar. If the user clicks "Enable Content," then the document is added as a trusted document.

    Important: If "Trust bar warning for digitally signed macros only (unsigned macros will be disabled)" is selected, users will not be able to open unsigned Access databases.

    Also, note that Microsoft Office stores certificates for trusted publishers in the Internet Explorer trusted publisher store. Earlier versions of Microsoft Office stored trusted publisher certificate information (specifically, the certificate thumbprint) in a special Office trusted publisher store. Microsoft Office still reads trusted publisher certificate information from the Office trusted publisher store, but it does not write information to this store.

    Therefore, if you created a list of trusted publishers in a previous version of Microsoft Office and you upgrade to Office, your trusted publisher list will still be recognized. However, any trusted publisher certificates that you add to the list will be stored in the Internet Explorer trusted publisher stor


    Regards, ~P MCSE, MCITP, MCTS, MCP, CCNA
    Wednesday, October 12, 2011 1:19 AM
  • Did Enable All Macros (not recommended) 

    User Config, Admin Templates, Microsoft Excel 2010, Excel Options, Security, Trust Center

    VBA Macro Notification Settings and for Excel 2007 VBA Macro Warning Settings

    Created a Test OU, linked this policy to it, and set for all Authenticated Users.  Placed my computer in the Test OU, gpupdate /force, and restarted my computer.  Login, start Excel 2010, File, Options, Trust Center, Trust Center Settings, Macro settings, and doesn't apply the GPO to change to Enable all macros, still stuck on Disable All macros.

    Thursday, October 13, 2011 4:05 PM
  • It sounds like your doing everything right. I just tested with mine and its works as it should. It is enabled and greyed out. Try creating another gpo for anything and see if it shows up.  Maybe you did not wait long enough for your test OU to replicate.


    Regards, ~P MCSE, MCITP, MCTS, MCP, CCNA
    • Edited by Gandalf50 Thursday, October 13, 2011 9:57 PM
    • Marked as answer by Yan Li_Moderator Monday, October 17, 2011 1:01 AM
    Thursday, October 13, 2011 9:57 PM