Checking for a Security Certificate

Summary: You can digitally sign your VBA projects to help ensure authenticity of your code and increase security. If you use such signatures, it is a good idea if your macros check to ensure that the signature is present. This tip explains how to do the check in VBA. (This tip works with Microsoft Word 2000, Word 2002, and Word 2003.)

Starting with Word 2000, you could "digitally sign" your documents and templates with a security certificate. Technically, it is the VBA projects attached to documents and templates that can be signed. In your macros you may want to verify that the certificate is in place. Checking for the signature programmatically can make it easier to manage the overall security efforts of a company.

The property you can use for this purpose is VBASigned. You can use it as follows:

Documents.Open FileName:="D:\dotfiles\temp.dot"
If Not ActiveDocument.VBASigned Then
    MsgBox "Warning! This document has not been digitally signed.", _
      vbCritical, "Digital Signature Warning"
End If

The VBASigned property will be either True or False, depending on whether the document (in this case a template) has been signed.

Tip #1461 applies to Microsoft Word versions: 2000 | 2002 | 2003

Great Idea! Word is a tool to get what you really want—printed output. This means you need to make sure that Word works as well as possible with your printer, whether it is sitting on your desk or in a room down the hall.

Check out WordTips: Printing and Printers today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Checking for a Security Certificate