Office Admin Explorer

Allow root or intermediate certificates as VBA trusted publishers

Registry value
vbadigsigchaintrustedpublishers
Group PolicyAllow root or intermediate certificates as VBA trusted publishers
German versionAllow root or intermediate certificates as VBA trusted publishers
Intune settings catalogAllow root or intermediate certificates as VBA trusted publishers (User)
ScopeUser · HKCU
ADMXoffice16.admx · L_VBADigSigChainTrustedPublishers
Open in the interactive explorer+ Add to my collection

Group Policy path

User Configuration\Policies\Administrative Templates\Microsoft Office 2016\Security Settings
Benutzerkonfiguration\Richtlinien\Administrative Vorlagen\Microsoft Office 2016\Sicherheitseinstellungen

Registry

ValueData
HKCU\Software\policies\microsoft\office\16.0\common\security
vbadigsigchaintrustedpublishersEnabled = 1 · 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\common\security"
foreach ($name in @('vbadigsigchaintrustedpublishers')) {
    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\common\security"
    if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
    New-ItemProperty -Path $key -Name 'vbadigsigchaintrustedpublishers' -PropertyType DWord -Value 1 -Force -ErrorAction Stop | Out-Null   # Enabled
    'Done.'
}
catch { Write-Error "Failed: $($_.Exception.Message)" }
Disable
# --- Settings ---
$root = 'HKCU:'   # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'

try {
    $key = "$root\Software\policies\microsoft\office\16.0\common\security"
    if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
    New-ItemProperty -Path $key -Name 'vbadigsigchaintrustedpublishers' -PropertyType DWord -Value 0 -Force -ErrorAction Stop | Out-Null   # Disabled
    '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\common\security"
Remove-ItemProperty -Path $key -Name 'vbadigsigchaintrustedpublishers' -ErrorAction SilentlyContinue
'Policy values removed (Not configured).'

Intune (settings catalog)

Allow root or intermediate certificates as VBA trusted publishers (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/office16v21~Policy~L_MicrosoftOfficeSystem~L_SecuritySettings/L_VBADigSigChainTrustedPublishers
Data typeString
Value<enabled/> · <disabled/>

Cloud Policy

Cloud Policy (config.office.com → Customization → Policy Management) offers many user policies of the Microsoft 365 Apps – search for Allow root or intermediate certificates as VBA trusted publishers. It also applies to unmanaged devices and wins over GPO and Intune for the same setting.

Microsoft explanation

This policy setting controls whether root and intermediate certificates can be added as trusted publishers for VBA macro validation when the VBA Macro Notification Settings policy is set to "Disable all except digitally signed macros".

If you enable this policy setting, administrators can add root or intermediate certificates to the trusted publishers store. VBA macros signed by any certificate that chains to these trusted root or intermediate certificates will be considered as signed by a trusted publisher and allowed to run.

If you disable or don't configure this policy setting, only end (leaf) certificates can be added as trusted publishers.

Note: This policy setting only takes effect when the VBA Macro Notification Settings policy is set to "Disable all except digitally signed macros".

Same category: Microsoft Office 2016 › Security Settings

All policies in this category · All 945 policies of office16.admx