Microsoft Office Tutorials and References
In Depth Information
Digitally Sign Your Excel Macros
Chapter 10: Maximizing Excel Security and Privacy
The Windows Security –
Confirm Certificate dialog
box appears.
Windows displays your
digital certificate.
Note: Remember that you only see
this digital certificate after you have
run the SelfCert.exe program, as
described in this section.
6 Click OK.
The certificate appears in
the Digital Signature
dialog box.
7 Click OK.
8 Switch to Excel, save the
workbook that you just
signed, and then close the
workbook (not shown).
9 Reopen the signed
workbook (not shown).
If you have macros
disabled, the Microsoft
Excel Security Notice
dialog box appears.
0 Click Trust All from
Excel opens the workbook
with macros enabled.
Excel no longer displays
the Security Notice dialog
box for workbooks signed
with your digital
Before you can digitally sign a VBA project, you must create a digital certificate for
signing your macros. Press Windows Logo+R to open the Run dialog box, type the
following address in the Open text box, and then click OK:
In the Create Digital Certificate dialog box, type your name in the Your Certificate’s
Name text box, and then click OK. Excel creates a digital certificate in your name and
displays a dialog box when it is done. Click OK. You can now use the digital certificate
to sign your VBA code, as described in this section.
Search JabSto ::

Custom Search