Disable predefined commands
| Registry value | filewebpagepreview |
| Group Policy | Disable predefined commands |
| German version | Vordefinierte Befehle deaktivieren |
| Intune settings catalog | Disable commands (User) |
| Scope | User · HKCU |
| ADMX | excel16.admx · L_Disablecommandbarbuttonsandmenuitems |
Group Policy path
Registry
| Value | Data |
|---|---|
HKCU\Software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes | |
| filewebpagepreview | Enabled = 3655 · Disabled = 0 |
| sendtomailrecipient | Enabled = 2188 · Disabled = 0 |
| inserthyperlink | Enabled = 1576 · Disabled = 0 |
| toolsprotectsheet | Enabled = 893 · Disabled = 0 |
| flyoutanchorprotectworkbookmenu | Enabled = 16132 · Disabled = 0 |
| toolsprotectshare | Enabled = 3059 · Disabled = 0 |
| flyoutanchormacros | Enabled = 16106 · Disabled = 0 |
| toolsmacromacros | Enabled = 186 · Disabled = 0 |
| toolsmacrorecord | Enabled = 184 · Disabled = 0 |
| toolsmacrosecurity | Enabled = 3627 · Disabled = 0 |
| toolsmacrovbe | Enabled = 1695 · Disabled = 0 |
| webaddress | Enabled = 1740 · Disabled = 0 |
Not configured = the value does not exist – the application default applies and users may change the setting.
PowerShell
Check the current value (read-only)
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
$key = "$root\Software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes"
foreach ($name in @('filewebpagepreview', 'sendtomailrecipient', 'inserthyperlink', 'toolsprotectsheet', 'flyoutanchorprotectworkbookmenu', 'toolsprotectshare', 'flyoutanchormacros', 'toolsmacromacros', 'toolsmacrorecord', 'toolsmacrosecurity', 'toolsmacrovbe', 'webaddress')) {
try { '{0} = {1}' -f $name, (Get-ItemPropertyValue -Path $key -Name $name -ErrorAction Stop) }
catch { '{0}: not configured' -f $name }
}Admin rights needed: HKCU\Software\Policies is read-only for standard users. An elevated session writes to the admin's own HKCU – to set it for another signed-in user, change $root to Registry::HKEY_USERS\<SID>.
Enable
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
try {
$key = "$root\Software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes"
if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
New-ItemProperty -Path $key -Name 'filewebpagepreview' -PropertyType DWord -Value 3655 -Force -ErrorAction Stop | Out-Null # Enabled
New-ItemProperty -Path $key -Name 'sendtomailrecipient' -PropertyType DWord -Value 2188 -Force -ErrorAction Stop | Out-Null # Enabled
New-ItemProperty -Path $key -Name 'inserthyperlink' -PropertyType DWord -Value 1576 -Force -ErrorAction Stop | Out-Null # Enabled
New-ItemProperty -Path $key -Name 'toolsprotectsheet' -PropertyType DWord -Value 893 -Force -ErrorAction Stop | Out-Null # Enabled
New-ItemProperty -Path $key -Name 'flyoutanchorprotectworkbookmenu' -PropertyType DWord -Value 16132 -Force -ErrorAction Stop | Out-Null # Enabled
New-ItemProperty -Path $key -Name 'toolsprotectshare' -PropertyType DWord -Value 3059 -Force -ErrorAction Stop | Out-Null # Enabled
New-ItemProperty -Path $key -Name 'flyoutanchormacros' -PropertyType DWord -Value 16106 -Force -ErrorAction Stop | Out-Null # Enabled
New-ItemProperty -Path $key -Name 'toolsmacromacros' -PropertyType DWord -Value 186 -Force -ErrorAction Stop | Out-Null # Enabled
New-ItemProperty -Path $key -Name 'toolsmacrorecord' -PropertyType DWord -Value 184 -Force -ErrorAction Stop | Out-Null # Enabled
New-ItemProperty -Path $key -Name 'toolsmacrosecurity' -PropertyType DWord -Value 3627 -Force -ErrorAction Stop | Out-Null # Enabled
New-ItemProperty -Path $key -Name 'toolsmacrovbe' -PropertyType DWord -Value 1695 -Force -ErrorAction Stop | Out-Null # Enabled
New-ItemProperty -Path $key -Name 'webaddress' -PropertyType DWord -Value 1740 -Force -ErrorAction Stop | Out-Null # Enabled
'Done.'
}
catch { Write-Error "Failed: $($_.Exception.Message)" }Reset to Not configured
# --- Settings --- $root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>' $key = "$root\Software\policies\microsoft\office\16.0\excel\disabledcmdbaritemscheckboxes" Remove-ItemProperty -Path $key -Name 'filewebpagepreview', 'sendtomailrecipient', 'inserthyperlink', 'toolsprotectsheet', 'flyoutanchorprotectworkbookmenu', 'toolsprotectshare', 'flyoutanchormacros', 'toolsmacromacros', 'toolsmacrorecord', 'toolsmacrosecurity', 'toolsmacrovbe', 'webaddress' -ErrorAction SilentlyContinue 'Policy values removed (Not configured).'
Intune (settings catalog)
Disable commands (User)
Settings catalog → Add settings → search for the name above.
Intune Settings Catalog Viewer ↗
Alternative: custom profile (OMA-URI)
| OMA-URI | ./User/Vendor/MSFT/Policy/Config/excel16v2~Policy~L_MicrosoftOfficeExcel~L_Disableitemsinuserinterface~L_Predefined/L_Disablecommandbarbuttonsandmenuitems |
| Data type | String |
| Value | <enabled/> · <disabled/> |
This policy has options: add one <data id="…" value="…"/> per element after <enabled/>. The element IDs are in the ADMX file.
Cloud Policy
Cloud Policy (config.office.com → Customization → Policy Management) offers many user policies of the Microsoft 365 Apps – search for Disable predefined commands. It also applies to unmanaged devices and wins over GPO and Intune for the same setting.
Microsoft explanation
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.
Same category: Microsoft Excel 2016 › Disable Items in User Interface › Predefined
All policies in this category · All 173 policies of excel16.admx