GPO: disable Office ribbon Menu items

15 Jun 2009

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

Share This:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • LinkedIn
  • PDF
  • Twitter

Comment Form