When people run your VBA macro, Office will check the signature and the certificate it was signed with. Adding a time stamp to your signature means that your macro will still be treated as signed, even after your certificate has expired, as long as the certificate isn't revoked.

Macros of VBA code Workbooks can have macros, VBA modules, COM or ActiveX controls, User Forms, or User-Defined Functions (UDFs) that may contain hidden data. Items that may have cached data Workbooks can have cached data for PivotTables, PivotCharts, slicers, timelines, and Cube formulas that might not be visible.

Use the Excel Desktop App to create, edit and run VBA macros. You can view and edit macro-enabled workbooks in Excel for the web, but you need to edit the macros themselves in the Excel Desktop App.

In Microsoft 365 and Office 2024, the settings for ActiveX controls have changed to be disabled by default. When ActiveX controls are disabled, you will not be able to create new ActiveX objects or interact with existing ones. This change applies to Word, Excel, PowerPoint, and Visio. What should I do if I encounter this ActiveX message when opening a file? Were you expecting to receive a file ...

To help protect your security and privacy, Microsoft Office is configured by default to block external content—such as images, linked media, hyperlinks, and data connections—in workbooks and presentations. Blocking external content helps to prevent Web beacons and other intrusive methods that hackers use to invade your privacy and lure you into running malicious code without your knowledge ...

Active content is additional functionality in a file or program, such as macros, add-ins, or data connections. This article lists types of active content that can be blocked by the settings in Trust Center and which, when present, will cause the display of a message bar upon opening the document. When active content is blocked, a Security Warning appears. If the file contains more than one ...

This security option is for code written to automate a Microsoft 365 program and manipulate the VBA environment and object model. It is a per-user and per-application setting, and denies access by default, hindering unauthorized programs from building harmful self-replicating code.

根据是否存在 VBA 工程，会出现两种情况： 使用 VBA 项目 禁用所有 ActiveX 控件，并显示消息栏。 单击 “启用内容” 以启用控件。 没有 VBA 项目 启用 SFI ActiveX 控件时的限制最小，并且不会显示消息栏。 但是，ActiveX 控件必须全部标记为 SFI 才不会生成消息栏。

使用此设置可以逐个启用宏。 在 Excel 中，此选项为 “禁用包含通知的 VBA 宏 ”，它仅适用于 VBA 宏。 禁用除数字签名宏之外的所有宏 宏处于禁用状态，如果存在未签名的宏，则显示安全警报。 但是，如果宏由受信任的发布者进行数字签名，则宏只会运行。

To learn about digital signatures (also known as digital ID), what they can be used for, and how to use them in Word, Excel, and PowerPoint, see All about digital signatures. Create a signature line in Word or Excel (desktop) In the document or worksheet, place your pointer where you want to create a signature line. On the Insert tab, select Add a Signature Line in the Text group. In the ...