Products Solutions Segments About Us Support Manage My Account


OmniRoot Certificate Center  >  Online Helpdesk  >  MS Office / VBA 2007

Signing code for Microsoft Office XP/VBA documents

In order to sign your Visual Basic for Applications (VBA) code in Microsoft Office XP, you will need to follow the following steps.
From your document, choose "Tools", then "Macro" and finally "Visual Basic Editor".

1


At this point the Visual Basic editor will open with the project name of the file you are working on. By right clicking on "Microsoft Word Objects" in the left hand pane, you should select "Insert" and then "Module".

2


You may now enter your visual basic code in the main panel.

From here you can sign your code with your ObjectSign digital certificate by choosing "Tools" and then "Digital Signature" from the top menu.

3


At this point another window will open and you will see the current signature associated with this Module, Office will also allow you to choose a certificate to either sign the module or change the certificate which has currently signed the module.
In order to sign the module with this certificate simply click "OK" or if you would prefer to select another certificate you can click "Choose".

4

If you choose to select a different certificate you will be presented with the following screen, from here select the certificate you wish to sign your code with and click "OK"

5

You will now see that the Module is signed with the chosen certificate.

6

You should now save your file from inside the visual basic editor.

7

In order to test that the VBA in the document has been properly signed, completely close the document from your office application and then reopen it.
If the module has been correctly signed, opening the document will give a "Security Warning" popup window which looks like the following screen.
From here a user will be able to view more information about the module(macro), all deatils about the signing certificate are available and the user will also be able to either enable or disable the macro.

8

  Related Topics:
Cybertrust OmniRoot
Certificate Center
Order an Code Signing Certificate

Online Helpdesk

Contact Support