自动为用户安装数字证书 [英] Automatically Install Digital Certificate For User

问题描述

这可能是不可能的，但我想我还是会问.我有一本Excel工作簿，可为我们的客户运行计算(他们需要Excel而不是EXE)，并且由于计算时间长且乏味，因此只能作为宏函数使用.

我已经使用selfcert为工作簿创建数字证书，但是我想知道是否存在一种创建VB.Net应用程序的方法，该应用程序可以为用户自动安装证书.

还相关，是否有一种方法可以更改宏安全性设置，以仅允许Excel内的受信任证书(因为默认设置是完全不信任任何宏)? (我知道这是一个远景，因为它违背了宏安全性的全部目的，但是问起来并没有什么害处.)如果不是这样，有没有一种方法可以检测到当前的安全级别，因此我可以通知用户他们需要的安全性改变它?

我知道您可以通过创建Excel加载项来绕开很多这些问题，但是宏基于具有特定工作表和数据布局的特定工作簿.因此，在这种情况下，外接程序不是解决方案.

谢谢Chris

This might not be possible, but I figured I would ask anyways. I have an Excel workbook that runs calculations for our customers (they want Excel and not an EXE), and since the calculations are very long and tedious, they are only possible as macro functions.

I have used selfcert to create a digital certificate for the workbook, but I want to know if there is a way of creating a VB.Net application that can install the certificate automatically for the user.

Also related, is there a way of changing the macro security settings to allow only trusted certificates within Excel (since the default is to not trust any macros at all)? (This one I know is a long shot since it goes against the whole purpose of macro security, but it does not hurt to ask.) If not, is there a way of detecting the current security level so I can inform the user they need to change it?

I know you can bypass a lot of these problems by creating an Excel addin, but the macros are based on a specific workbook with specific sheets and data layouts. So an addin is not a solution in this scenario.

Thanks, Chris

推荐答案

您可以在.Net中轻松添加证书，请参见

You can add a certificate fairly easily in .Net, see this page[^] for an example.

这篇关于自动为用户安装数字证书的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！