Microsoft has discovered a vulnerability in Office Visual Basic for Applications (VBA) macro project signing. This vulnerability might enable a malicious user to tamper with a signed VBA project without invalidating its digital signature. Therefore, we recommend that users apply the security updates that are listed in Microsoft Common Vulnerabilities and Exposures CVE-2020-0760.

To enhance the security of the Office VBA macro project signing, Microsoft provides a more secure version of VBA project signature scheme: V3 signature. The V3 signature is available in the following products: 

We recommend that organizations apply the V3 signature to all macros to eliminate the risk of tampering. 

By default, to ensure backward compatibility, VBA files that have existing signatures will continue to work, and files that are signed by using the V3 signature can be opened and run in earlier versions of Office or in non-updated Office clients. However, we recommend that admins upgrade the existing VBA signatures to the V3 signature as soon as possible after they upgrade Office to the listed versions. After admins verify that there is no compatibility loss to the organization, they can disable the old VBA signatures by enabling the Only trust VBA macros that use V3 signatures policy setting. For more information about this policy setting, see the "Enable policy setting: Only trust VBA macros that use V3 signatures" section.

Upgrade signed VBA files to the V3 signature

Admins can use the following topics to upgrade existing VBA signatures files to the V3 signature.

Create an inventory of signed VBA files

If you already have an inventory of all existing signed VBA files, you can skip this section. If not, use the Readiness Toolkit for Office add-ins and VBA to create an inventory of the existing signed VBA files that have to be upgraded. The tool will generate a report that lists files that have to be upgraded together with their file locations. For more information about the Readiness Toolkit, see Use the Readiness Toolkit to assess application compatibility for Microsoft 365 Apps.

  1. Download the Readiness Toolkit for Office add-ins and VBA.

  2. Run PowerShell or open a Command Prompt window as administrator, and then navigate to the Readiness Toolkit installation folder:

    C:\Program Files (x86)\Microsoft Readiness Toolkit for Office

  3. Run the following command to scan a folder where your VBA files are located (for example, C:\Test_ToolKit):

    ReadinessReportCreator.exe -sigscan -p C:\Test_ToolKit -r -output C:\output

    Run command line to scan a folder

    After the scan, a JSON result file is created in the C:\output folder.

  4. From the Readiness Toolkit installation folder, run the ReadinessReportCreator.exe file to open the results file.

    Screenshot of running ReadinessReportCreator.exe

    In the results file, find all the unsafe macros files that you have to upgrade to the V3 signature.

    Screenshot of the result file

    Screenshot of unsafe macro signatures

Use VBA Editor to re-sign VBA files 

If you have private certificates, use the Visual Basic for Applications (VBA) Editor that's provided in an Office application to re-sign the VBA files.

  1. To re-sign a VBA file, press Alt+F11 from within the file to open the VBA Editor.

  2. To replace an existing signature with the V3 signature, select Tools Digital Signature. The Digital Signature dialog box opens.

    Note: To sign a VBA project, the private key must be correctly installed. For more information, see Digitally sign your macro project.

    Screenshot of selecting Digital Signature

  3. Select Choose to choose the certificate private key to use to sign the VBA project, and then select OK.

    Select a certificate

  4. To generate the new signatures, save the file again. The new digital signatures will replace the previous signatures.

Use SignTool to re-sign VBA files

SignTool in the Windows 10 SDK can help you re-sign the VBA files through a command line. To batch the re-signing work against the inventory list that's identified in the "Create an inventory of signed VBA files" section, you can integrate SignTool into your own admin tools.

Note: Currently, SignTool doesn't support Microsoft Access.

To re-sign VBA files by using SignTool, follow these steps:

  1. Download and install the Windows 10 SDK.

  2. Download Officesips.exe from Microsoft Office Subject Interface Packages for Digitally Signing VBA Projects.

  3. To sign files and verify the signatures in files, register Msosip.dll and Msosipx.dll, and then run Offsign.bat. The detailed steps are included in the Readme.txt file in the installation folder of Officesips.exe.

Note: Use the x86 version of SignTool in the "C:\Program Files (x86)\Windows Kits\10\bin\10.0.18362.0\x86" folder when you run Offsign.bat.

Enable policy setting: "Only trust VBA macros that use V3 signatures"

After you complete the upgrade to the V3 signatures, we recommend that you enable the Only trust VBA macros that use V3 signatures policy setting to make sure that only V3 signature-signed files are trusted.

This policy setting is available in Group Policy or the Office Cloud Policy Service. It is located in User Configuration\Policies\Administrative Templates\Microsoft Office 2016\Security Settings\Trust Center. If this setting is enabled, only the V3 signature will be considered as valid when Office validates the digital signature in files. Earlier-format signatures in VBA files will be ignored.

Analyze the effect of applying the policy setting by using Security Policy Advisor

Security Policy Advisor is available in the Apps Admin Center in Microsoft 365 version 2103 (build 16.0.13824.10000) and later versions of the current channel. It provides information about the security and productivity effect of applying the Only trust VBA macros that use V3 signatures policy setting.

To analyze the productivity effect, admins can examine the Recommendation details pane to see which users are protected when this policy setting is applied. These insights can help admins make data-informed decisions by measuring the benefits and costs of applying the policy setting.

View impact of applying policy settings with SPA

Additionally, admins can use a one-click deployment for this policy setting. Security Policy Advisor uses Office cloud policy service to enforce Office policy settings for Microsoft 365 Apps for enterprise directly from the cloud. This works for both managed and unmanaged devices. After deploying the policy setting by using Office cloud policy service, admins can revisit the Recommendation details pane to monitor how the policy setting is affecting users.

For more information about how to enable Security Policy Advisor in your environment, see Overview of Security Policy Advisor for Microsoft 365 Apps for enterprise.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×