here<\/a><\/p>\nProcedure:<\/p>\n
1. Install pvkimport you downloaded from Microsoft. Remember the paths to where you
\ninstalled it (c:\\codesign\\). You may also copy your certificate\/key files to this directory
\n(mycert.spc & mykey.pvk).
\n2. Open a command-prompt and change to the folder where you installed pvkimport.
\n(c:\\codesign\\).
\n3. Combine your SPC and PVK certificate\/key files that you received from Comodo into a
\nPFX file using pvkimport: (c:\\codesign> pvkimprt -import \u2013pfx c:\\codesign\\mycert.spc
\nc:\\codesign\\mycert.pvk)
\nThis will start a wizard. Choose options:
\nYes, Export the Private Key (check)
\nInclude all Certificates in Path if possible (check)
\nEnable strong protection (uncheck)
\nDelete the private key if export is successful (uncheck)
\nEnter a password
\nChoose a location (c:\\firefoxext\\mycert.pfx)
\nFinish.
\n4. You can check the private key has been imported successfully by using MMC. Open MMC,
\nselect add\/remove snap in and select certificates. Opening your code signing certificate
\nshould show code signing usage and that you have the private key.
\n5. Within your Office 2K document, open the Visual Basic editor from the Tools \u2013 Macro
\nmenu.
\n6. Open the VBA project you wish to sign, and select Digital Signature from the Tools menu.
\n7. Select Chose from the Digital Signature window and your code signing certificate that you
\nwish to use to sign your VBA macro.
\n8. Click OK followed by Save, close to return to your Office document. Your macro is now
\ndigitally signed.<\/p>\n
Please note to add a friendly name to the certificate before using the certificate. How can this be changed?<\/p>\n
Friendly name within the MMC snap in window.<\/p>\n
Click the Start Button then select Run and type mmc Click File and select Add\/Remove Snap in Select Add,
\nselect Certificates from the Add Standalone Snap-in box and click Add Select Computer Account and click
\nFinish (note: This step is very important. It must be the computer account and not the current user account)
\nClose the Add Standalone Snap-in box, click OK in the Add\/Remove Snap in Return to the MMC To modify
\nthe friendly name go to the Personal, certificates Select the code sign cert and right click Properties<\/p>\n
You should now see the friendly name field which can be modified to suit your needs.<\/p>\n","protected":false},"excerpt":{"rendered":"
VBA signing Office 2K & XP VBA Macros Signing Microsoft Office 2K & XP VBA Macros with a Comodo Code-Signing Certificate. Must have these: * Microsoft’s tool to import PVK files: Download the PVK import tool from Microsoft (pvkimprt.exe) * Your code signing certificate from Comodo (as PVK and SPC\u2026<\/p>\n
Continue reading<\/span><\/i><\/a> <\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/pages\/239"}],"collection":[{"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/comments?post=239"}],"version-history":[{"count":3,"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/pages\/239\/revisions"}],"predecessor-version":[{"id":609,"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/pages\/239\/revisions\/609"}],"wp:attachment":[{"href":"https:\/\/pkipartner.com\/support\/wp-json\/wp\/v2\/media?parent=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}