Office Admin Explorer

Turn off Trusted Documents for VBA macros

Registry value
blockvbamacrotrusteddocument
Group PolicyTurn off Trusted Documents for VBA macros
German versionTurn off Trusted Documents for VBA macros
Intune settings catalogTurn off Trusted Documents for VBA macros (User)
ScopeUser · HKCU
ADMXoffice16.admx · L_BlockVBAMacroTrustedDocument
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
blockvbamacrotrusteddocumentEnabled = 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 @('blockvbamacrotrusteddocument')) {
    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 'blockvbamacrotrusteddocument' -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 'blockvbamacrotrusteddocument' -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 'blockvbamacrotrusteddocument' -ErrorAction SilentlyContinue
'Policy values removed (Not configured).'

Intune (settings catalog)

Turn off Trusted Documents for VBA macros (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_BlockVBAMacroTrustedDocument
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 Turn off Trusted Documents for VBA macros. It also applies to unmanaged devices and wins over GPO and Intune for the same setting.

Microsoft explanation

This policy setting allows you to turn off the Trusted Documents feature for documents containing VBA macros.

If you enable this policy setting, users will always see security notifications for VBA macros in documents. When users click "Enable Content" for VBA macros, Office will not create a trust record for the document, ensuring that the user is prompted every time they open the document.

If you disable or don't configure this policy setting, the Trusted Documents feature allows users to always allow VBA macros in a document so that the user is not prompted the next time they open that document. Trusted documents are exempt from security notifications.

Note: Enabling this policy setting does not clear existing trusted documents that were previously trusted.

Same category: Microsoft Office 2016 › Security Settings

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