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.
6
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).
7
If you have macros
disabled, the Microsoft
Excel Security Notice
dialog box appears.
0 Click Trust All from
Publisher.
Excel opens the workbook
with macros enabled.
Excel no longer displays
the Security Notice dialog
box for workbooks signed
with your digital
signature.
0
Important!
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:
%ProgramFiles%\MicrosoftOffice\Office14\SelfCert.exe
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