Microsoft Office VBA代码的数字证书/签名 [英] Digital Certificates /signatures for Microsoft Office VBA code

问题描述

我的任务是在Office 2013中将公司模板和VBA宏代码应用于数字证书。

我的问题是：

你如何做到这一点。

你如何管理证书或防止证书到期。例如，使用供应商Office模板和VBA代码，这发生在我们身上。结果是供应商的功能无法使用，我们不得不等待2-3天供应商以
续订证书并向我们提供他们更新的模板VBA代码。

用户创建的宏

用户创建自己的宏来协助他们的工作。宏可以在Word VBA或Excel VBA中。你如何推荐管理/监管 这个场景

TIA

解决方案

你好
dd _，

您可以创建自签名证书。

因为您创建的数字证书不是由正式的可信证书颁发机构颁发的，所以使用签名的宏项目此类证书称为
自签名项目。 Microsoft Office仅在具有添加到
的自签名证书的计算机上信任自签名证书受信任的根证书文件夹

创建自签名证书

   ;  

Windows 7，Windows Vista或Windows XP

1. 
   

   点击开始，指向所有程序，单击
   Microsoft Office ，单击 Microsoft Office工具，然后单击
   VBA项目的数字证书。
   
   将出现创建数字证书对话框。

   
         
2. 
   

   在您的证书名称框中，输入证书的描述性名称。

   
     
3. 
   

   点击确定。

   
          
4. 
   

   当出现SelfCert Success消息时，请单击确定。

   
      

使用Internet Explorer查看证书

查看证书在个人证书存储区中，执行以下操作：

        

1. 
   

   打开Internet Explorer。

   
       
2. 
   

   在工具菜单上，点击互联网选项，然后点击
   内容标签。

   
   
3. 
   

   点击证书，然后点击个人标签。

   
   

在Excel，PowerPoint，Publisher，Visio，Outlook中对一个宏项目进行数字签名，或Word

      

1. 
   

   打开包含您要签名的宏项目的文件。

   
     
2. 
   

   在开发人员标签上的代码组中，点击
   Visual Basic 。

   
   

   注意： 如果"开发者"标签不可用：点击
   文件标签。点击选项。点击自定义功能区。在
   自定义功能区列表中，点击开发者，然后点击
   确定。

Ive been tasked with applying digital certificates on our company templates and VBA macro code in Office 2013.

My questions are:

how do you go about doing this.

how do you manage certificates or guard against certificate expiry. for example this happened to us once with a vendor Office template and VBA code. The result was the vendors functionality couldn’t be used, and we had to wait 2-3 days for the vendor to renew the certificate and supply us with their updated templates VBA code.

User created macros

Users create their own macros to assist with their work. macros can be in Word VBA or Excel VBA. how do you recommend managing/ policing  this scenario

TIA

解决方案

Hi dd_,

you can create a self-signing certificate.

Because a digital certificate that you create isn't issued by a formal trusted certificate authority, macro projects that are signed by using such a certificate are known as self-signed projects. Microsoft Office trusts a self-signed certificate only on a computer that has the self-signing certificate added to the Trusted Root Certification folder in the Certificates - Current User store

Create a self-signing certificate

    

Windows 7, Windows Vista, or Windows XP

1. Click Start, point to All Programs, click Microsoft Office, click Microsoft Office Tools, and then click Digital Certificate for VBA Projects.
   The Create Digital Certificate dialog box appears.

        

2. In the Your certificate's name box, type a descriptive name for the certificate.

     

3. Click OK.

          

4. When the SelfCert Success message appears, click OK.

      

View the certificate by using Internet Explorer

To view the certificate in the Personal Certificates store, do the following:

        

1. Open Internet Explorer.

       

2. On the Tools menu, click Internet Options, and then click the Content tab.

3. Click Certificates, and then click the Personal tab.

Digitally sign a macro project in Excel, PowerPoint, Publisher, Visio, Outlook, or Word

      

1. Open the file that contains the macro project that you want to sign.

     

2. On the Developer tab, in the Code group, click Visual Basic.

   Note: If the Developer tab is not available: Click the File tab. Click Options. Click Customize Ribbon. In the Customize the Ribbon list, click Developer, and then click OK.

这篇关于Microsoft Office VBA代码的数字证书/签名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！