Disable predefined commands
Jump to overview

Policy overview

Key metadata and intent for this policy.

User
Category
Microsoft Excel 2016 > Disable Items in User Interface > Predefined
Supported on
Windows7

This policy setting allows you to disable specific command bar buttons and menu items in the specified applications. If you enable this policy setting you can disable specific command bar buttons and menu items in the user interface for the selected application. The predefined list of command bar buttons and menu items you can disable becomes available to you when you enable this policy setting. If you disable or do not configure this policy setting, the predefined list of command bar buttons and menu items are enabled for the application.

Internal name
L_Disablecommandbarbuttonsandmenuitems
Policy ID
4ee9c07fdea3
Elements
12

Registry values

How enabled and disabled states update the registry.

No explicit registry values are set for enabled or disabled states.

Policy elements

Inputs and configuration options exposed by this policy.

ScopeElementTypeRegistry mappingConstraints & behaviorCopy
User
File tab | Options | Customize Ribbon | All Commands | Web Page Preview
ID L_OfficeButtonxcelOptionsCustomizationCombinedPreviewWebPagePreview
boolean
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
filewebpagepreview
Type
REG_SZ
Options: true (3655), false (0)
True: Set value = "3655" · False: Set value = "0"
User
File tab | Share | Email
ID L_OfficeButtonExcelOptionsCustomizationMailRecipient
boolean
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
sendtomailrecipient
Type
REG_SZ
Options: true (2188), false (0)
True: Set value = "2188" · False: Set value = "0"
User
Insert tab | Links | Hyperlink
ID L_InsertLinksHyperlink
boolean
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
inserthyperlink
Type
REG_SZ
Options: true (1576), false (0)
True: Set value = "1576" · False: Set value = "0"
User
Review tab | Changes | Protect Sheet
ID L_ReviewChangesProtectSheet
boolean
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
toolsprotectsheet
Type
REG_SZ
Options: true (893), false (0)
True: Set value = "893" · False: Set value = "0"
User
Review tab | Changes | Protect Workbook
ID L_ReviewChangesProtectWorkbook
boolean
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
flyoutanchorprotectworkbookmenu
Type
REG_SZ
Options: true (16132), false (0)
True: Set value = "16132" · False: Set value = "0"
User
Review tab | Changes | Protect and Share Workbook
ID L_ReviewChangesProtectSharing
boolean
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
toolsprotectshare
Type
REG_SZ
Options: true (3059), false (0)
True: Set value = "3059" · False: Set value = "0"
User
View tab | Macros | Macros
ID L_ViewMacrosMacros
boolean
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
flyoutanchormacros
Type
REG_SZ
Options: true (16106), false (0)
True: Set value = "16106" · False: Set value = "0"
User
Developer tab | Code | Macros
ID L_DeveloperCodeMacros
boolean
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
toolsmacromacros
Type
REG_SZ
Options: true (186), false (0)
True: Set value = "186" · False: Set value = "0"
User
Developer tab | Code | Record Macro
ID L_DeveloperCodeRecordMacro
boolean
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
toolsmacrorecord
Type
REG_SZ
Options: true (184), false (0)
True: Set value = "184" · False: Set value = "0"
User
Developer tab | Code | Macro Security
ID L_DeveloperCodemacroSecurity
boolean
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
toolsmacrosecurity
Type
REG_SZ
Options: true (3627), false (0)
True: Set value = "3627" · False: Set value = "0"
User
Developer tab | Code | Visual Basic
ID L_DeveloperCodeVisualbasic
boolean
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
toolsmacrovbe
Type
REG_SZ
Options: true (1695), false (0)
True: Set value = "1695" · False: Set value = "0"
User
File tab | Options | Customize Ribbon | All Commands | Document Location
ID L_OfficeButtonExcelOptionsCustomizeDocumentLocation
boolean
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
webaddress
Type
REG_SZ
Options: true (1740), false (0)
True: Set value = "1740" · False: Set value = "0"
File tab | Options | Customize Ribbon | All Commands | Web Page Preview
User · Type boolean
Registry mapping
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
filewebpagepreview
Type
REG_SZ
Details
Options: true (3655), false (0)
True: Set value = "3655" · False: Set value = "0"
File tab | Share | Email
User · Type boolean
Registry mapping
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
sendtomailrecipient
Type
REG_SZ
Details
Options: true (2188), false (0)
True: Set value = "2188" · False: Set value = "0"
Insert tab | Links | Hyperlink
User · Type boolean
Registry mapping
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
inserthyperlink
Type
REG_SZ
Details
Options: true (1576), false (0)
True: Set value = "1576" · False: Set value = "0"
Review tab | Changes | Protect Sheet
User · Type boolean
Registry mapping
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
toolsprotectsheet
Type
REG_SZ
Details
Options: true (893), false (0)
True: Set value = "893" · False: Set value = "0"
Review tab | Changes | Protect Workbook
User · Type boolean
Registry mapping
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
flyoutanchorprotectworkbookmenu
Type
REG_SZ
Details
Options: true (16132), false (0)
True: Set value = "16132" · False: Set value = "0"
Review tab | Changes | Protect and Share Workbook
User · Type boolean
Registry mapping
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
toolsprotectshare
Type
REG_SZ
Details
Options: true (3059), false (0)
True: Set value = "3059" · False: Set value = "0"
View tab | Macros | Macros
User · Type boolean
Registry mapping
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
flyoutanchormacros
Type
REG_SZ
Details
Options: true (16106), false (0)
True: Set value = "16106" · False: Set value = "0"
Developer tab | Code | Macros
User · Type boolean
Registry mapping
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
toolsmacromacros
Type
REG_SZ
Details
Options: true (186), false (0)
True: Set value = "186" · False: Set value = "0"
Developer tab | Code | Record Macro
User · Type boolean
Registry mapping
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
toolsmacrorecord
Type
REG_SZ
Details
Options: true (184), false (0)
True: Set value = "184" · False: Set value = "0"
Developer tab | Code | Macro Security
User · Type boolean
Registry mapping
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
toolsmacrosecurity
Type
REG_SZ
Details
Options: true (3627), false (0)
True: Set value = "3627" · False: Set value = "0"
Developer tab | Code | Visual Basic
User · Type boolean
Registry mapping
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
toolsmacrovbe
Type
REG_SZ
Details
Options: true (1695), false (0)
True: Set value = "1695" · False: Set value = "0"
File tab | Options | Customize Ribbon | All Commands | Document Location
User · Type boolean
Registry mapping
Path
software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes
Value name
webaddress
Type
REG_SZ
Details
Options: true (1740), false (0)
True: Set value = "1740" · False: Set value = "0"