GPO: disable Office ribbon Menu items

Problem:

  • I needed to disable a menu item in Excel 2007.

Resolution:

  • First of all download the ADM(X) templates for Office 2007 (keep in mind I am using server 2008). You can download them here
  • Extract it to a folder, and then copy the contents of the admx folder to C:\Windows\PolicyDefinitions
  • Open your Group Policy Editor (gpmc.msc), and make a new Group Policy (I named it “Office GPO”
  • If you browse to [User Configuration], [Administrative Templates], you will see all the Office Policy Definitions.
    Office Policy Definitions
  • My task was to disable the Menu Items “From Other Sources”, “Existing Connections” and “Connection”.
    You can disable menu items under the group policy setting:
    [Administrative Templates\Microsoft Office Excel 2007\Disable Items in User Interface\Custom\Disable Commands\
  • The Disable Commands works with ID numbers, you can find these here
    For my problem I had to disable ID’s: 11205, 12495 and 12496

    Disable Command Properties

One thought on “GPO: disable Office ribbon Menu items

  1. Pingback: Kasper de Jonge BI Blog » Disable SSAS access from Excel using group policies

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>