Ouvrir dans l'explorateur

VBA Macro Notification Settings

Cette stratégie n'a pas de traduction française dans les modèles de l'éditeur ; le texte original est en anglais.

Type
Utilisateur
Chemin GPO
Configuration utilisateur › Stratégies › Modèles d'administration › Microsoft Access 2016 › Paramètres de l’application › Sécurité › Centre de gestion de la confidentialité EN : User Configuration › Policies › Administrative Templates › Microsoft Access 2016 › Application Settings › Security › Trust Center
Pris en charge sur
At least Windows Server 2008 R2 or Windows 7
Fichier ADMX
access16.admx
Nom interne
access16/L_VBAWarningsPolicy

Explication

This policy setting controls how the specified applications warn users when Visual Basic for Applications (VBA) macros are present.

If you enable this policy setting, you can choose from four options for determining how the specified applications will warn the user about macros:

- Disable all with notification: The application displays the Trust Bar for all macros, whether signed or unsigned. This option enforces the default configuration in Office.

- Disable all except digitally signed macros: The application displays the Trust Bar for digitally signed macros, allowing users to enable them or leave them disabled. Any unsigned macros are disabled, and users are not notified.

- Disable all without notification: The application disables all macros, whether signed or unsigned, and does not notify users.

- Enable all macros (not recommended): All macros are enabled, whether signed or unsigned. This option can significantly reduce security by allowing dangerous code to run undetected.

If you disable this policy setting, "Disable all with notification" will be the default setting.

If you do not configure this policy setting, when users open files in the specified applications that contain VBA macros, the applications open the files with the macros disabled and display the Trust Bar with a warning that macros are present and have been disabled. Users can inspect and edit the files if appropriate, but cannot use any disabled functionality until they enable it by clicking "Enable Content" on the Trust Bar. If the user clicks "Enable Content", then the document is added as a trusted document.

If you select “Disable all except digitally signed macros” we recommend that you also select the “Require macros to be signed by a trusted publisher” check box to help improve security.

If you select the “Require macros to be signed by a trusted publisher” check box, users opening files with digitally signed macros but not by a Trusted Publisher will receive a notification that macros are blocked from running. And there are two additional check boxes that we recommend that you select to help improve security.

- Block certificates from trusted publishers that are installed in the current user certificate store

- Require Extended Key Usage (EKU) for certificates from trusted publishers

Note: These two check boxes only apply if you have selected the "Require macros to be signed by a trusted publisher" check box.

Note: All three check boxes only apply to Version 2012 and later of Office and Visio. They don’t apply to Office 2016 or Office 2019.

If you select the “Block certificates from trusted publishers that are installed in the local machine certificate store” check box, macros won’t run if the certificate from the trusted publisher is installed in the current user certificate store. The certificate must be installed in the local machine certificate store for the macro to run. Only accounts with administrator access to the computer can install a certificate in the local machine certificate store.

If you select the “Require Extended Key Usage (EKU) for certificates from trusted publishers” check box, the EKU must include “Code Signing” as one of the uses of the certificate.

Important: If "Disable all except digitally signed macros" is selected, users will not be able to open unsigned Access databases.

Also, note that Microsoft Office stores certificates for trusted publishers in the Internet Explorer trusted publisher store. Earlier versions of Microsoft Office stored trusted publisher certificate information (specifically, the certificate thumbprint) in a special Office trusted publisher store. Microsoft Office still reads trusted publisher certificate information from the Office trusted publisher store, but it does not write information to this store.

Therefore, if you created a list of trusted publishers in a previous version of Microsoft Office and you upgrade to Office, your trusted publisher list will still be recognized. However, any trusted publisher certificates that you add to the list will be stored in the Internet Explorer trusted publisher store.

Registre

HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\access\security
Nom de la valeur
non défini dans l'ADMX

Valeurs d'activation / désactivation : non défini dans l'ADMX (voir les options ci-dessous).

PowerShell

Commandes PowerShell qui écrivent dans le registre ce que la stratégie écrirait. Les valeurs entre chevrons (<…>) sont à remplacer.

Écrire directement dans le registre contourne la stratégie de groupe : si une GPO gère cette valeur, elle sera réécrite au prochain gpupdate ; sinon la valeur reste en place (effet « tatouage »). Préférez une GPO ou, en local, LGPO.exe. Exécutez PowerShell en administrateur pour HKLM. Certaines stratégies demandent un redémarrage ou gpupdate /force.

Activer

# Activer : access16/L_VBAWarningsPolicy
$k = 'HKCU:\software\policies\microsoft\office\16.0\access\security'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
#
# Options possibles :
#   Disable all with notification = 2
#   Disable all except digitally signed macros = 3
#   Disable all without notification = 4
#   Enable all macros (not recommended) = 1
Set-ItemProperty -Path $k -Name 'vbawarnings' -Value 2 -Type DWord
# Require macros to be signed by a trusted publisher
# décoché : 0
Set-ItemProperty -Path $k -Name 'vbadigsigtrustedpublishers' -Value 1 -Type DWord
# Block certificates from trusted publishers that are only installed in the current user certificate store
# décoché : 0
Set-ItemProperty -Path $k -Name 'vbarequirelmtrustedpublisher' -Value 1 -Type DWord
# Require Extended Key Usage (EKU) for certificates from trusted publishers
# décoché : 0
Set-ItemProperty -Path $k -Name 'vbarequiredigsigwithcodesigningeku' -Value 1 -Type DWord

Désactiver

# Désactiver : access16/L_VBAWarningsPolicy
# Aucune valeur n'est écrite à l'état « Désactivé » (rien de défini dans l'ADMX)

Revenir à « Non configuré »

# Revenir à « Non configuré » : access16/L_VBAWarningsPolicy
$k = 'HKCU:\software\policies\microsoft\office\16.0\access\security'
Remove-ItemProperty -Path $k -Name 'vbawarnings' -ErrorAction SilentlyContinue
Remove-ItemProperty -Path $k -Name 'vbadigsigtrustedpublishers' -ErrorAction SilentlyContinue
Remove-ItemProperty -Path $k -Name 'vbarequirelmtrustedpublisher' -ErrorAction SilentlyContinue
Remove-ItemProperty -Path $k -Name 'vbarequiredigsigwithcodesigningeku' -ErrorAction SilentlyContinue

Options (4)

LibelléContrôleValeur de registreType REGContraintes / détails
L_EmptyListe déroulanteenumvbawarningsREG_DWORD
Choix par défaut (interface) : n° 0
LibelléValeur
Disable all with notificationREG_DWORD = 2
Disable all except digitally signed macrosREG_DWORD = 3
Disable all without notificationREG_DWORD = 4
Enable all macros (not recommended)REG_DWORD = 1
Require macros to be signed by a trusted publisherL_VBADigSigTrustedPublishersStrCase à cocherbooleanvbadigsigtrustedpublishersREG_DWORD
Coché : REG_DWORD = 1
Décoché : REG_DWORD = 0
Block certificates from trusted publishers that are only installed in the current user certificate storeL_VBAOnlyAllowLMTrustedPublisherStrCase à cocherbooleanvbarequirelmtrustedpublisherREG_DWORD
Coché : REG_DWORD = 1
Décoché : REG_DWORD = 0
Require Extended Key Usage (EKU) for certificates from trusted publishersL_VBAOnlyAllowDigSigWithCodeSigningEKUStrCase à cocherbooleanvbarequiredigsigwithcodesigningekuREG_DWORD
Coché : REG_DWORD = 1
Décoché : REG_DWORD = 0

Application

Microsoft 365 Apps / Office (Microsoft) — modèles de novembre 2026

Modèles officiels téléchargés le 12 novembre 2026.