如何省略VBA签名警告对话框（使用数字签名时） [英] How to omit VBA signature warning dialogs (when with digital signature)

问题描述

嗨 - 我必须有另一个签名问题; - ）

Hi - I must have a yet-another-signature question ;-)

我们的Excel设置为在进行数字签名时运行宏。我有一个Excel 2k7工作表和一些VBA，它通过Access数据库启动，用于某些数据表示。为了没有bugger用户，我尝试自我签署VBA代码，用户在添加"我"之后工作正常
。致信的发布商。

（或者我制作了一个脚本，通过certutil将我的证书添加到受信任的发布者）

Our Excel is set to run macros when they are digitally signed. I have an Excel 2k7 worksheet with some VBA that gets launched via an Access Database for some data representation. In order to no bugger users I tried self-signing the VBA-code which works fine after the user has once added "me" to trusted publishers.
(or I make a script that adds my cert to trusted publishers via certutil)

为了省略此警告并测试/模拟第三方CA I使自己成为一个自己的CA证书，现在受到信任的根源。但是，当使用此CA颁发的代码签名证书对代码进行签名时，它不会通过自签名证书进行任何更改。
即第一次阻止VBA代码和完全相同的消息框，因此用户看不到它来自受信任的根。 - 在这种情况下，我认为使用3rdy派对证书比使用自签名证书没有任何优势，因为大多数情况下用户只是不检查信任
链（最明显的是消息框完全相同） 。

In order to omit this warning and test/simulate a 3rd party CA I made myself an own CA cert which is now under trusted roots. But when signing the code with a code signing certificate issued by this CA it doesn't change anything over a self-signed certificate. i.e. VBA code is blocked for first time and exact same message box, so the user doesn't see it comes from a trusted root. - In this case I don't see any advantages using a 3rdy party cert over a self-signed one since most often users just don't check the trust chain (most notably that the message box is exactly the same).

我希望从更有经验的开发人员那里得到一些答案...

I hope to get some answers from more experienced developers ...

推荐答案

你好，

这篇关于如何省略VBA签名警告对话框（使用数字签名时）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！