Excel VBA 宏工作簿启动 - 安全警告 - 禁用自动更新链接
我已经创建了一个加载项并安装了它，但现在当我打开 Excel 时，我收到一个错误弹出窗口，告诉我该加载项文件存在安全风险，并且链接的自动更新已被禁用。我查了一下，它指的是 Windows DDE 协议，但这与这个加载项有什么关系呢？有谁知道这里的幕后发生了什么？
谢谢
I've created an add-in and installed it, but now when I open Excel I get an error pop-up telling me that the add-in file is a security risk and that automatic updating of links is disabled. I've looked it up and it refers to the Windows DDE protocol, but what does that have to do with this add-in? Does anyone know what's happening behind the scenes here?
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
Excel 不知道该加载项是否真正受信任，因此它会终止动态数据交换，以便您闪亮的新加载项无法在用户不知情的情况下下载恶意代码。您需要告诉 Excel 使用 Excel 信任中心信任该插件（Office 按钮 > Excel 选项 > 信任中心 > 信任中心设置按钮）。查看“加载项”部分和“宏设置”部分。
您可能需要考虑的一件事是使用证书签署您的代码（Vb 编辑器中的工具 > 数字签名），然后让您的最终用户将您的证书添加到受信任的发布者。如果您的最终用户位于域设置中，则可以将受信任的发布者设置为域策略，这样最终用户甚至不必考虑它。
Excel does not know if the add-in is truly trusted so it is killing Dynamic Data Exchange so that your shiny new add-in can't download malicious code without the user knowing it. You are going to want to tell Excel to trust the plugin using the Excel trust center (Office Button > Excel Options > Trust Center > Trust Center Settings Button). Look at both the Add-Ins section and the Macro Settings section.
One thing you might want to consider is signing your code with a certificate (tools > Digital Signature in the Vb editor) and then having your end users add your cert to the trusted publishers. If your end users are in a domain setting, the trusted publishers can be set as a domain policy so the end users won't even have to think about it.