Judy
Since we don't know what exercise 7 refers to, hard to tell what steps you
have taken.
KB Article on certificates, including SelfCert.
http://support.microsoft.com/default...b;en-us;288985
After you get the certificate created you can check its properties. It will
be "untrusted".
To make it into a Trusted Certificate you must open the Microsoft Management
Console(Windows XP) by StartRun "mmc"(no quotes).
FileAdd/Remove Snap-inCertificates.
Your new certificate will be under the Personal category.
Copy and paste it into the Trusted Certificates category. Ignore the alerts
and click Yes.
These selfcerts are machine-specific but can be used for multiple files.
Close out MMC and open Excel and your workbook.
ToolsOptionsSecurityDigital SignaturesAdd. Add the signature.
Then you hit ALT + F11 to open the Visual Basic Editor.
ToolsDigital Signatures follow steps to sign the project.
Save file and close it.
Next time you open you should get the pop-up screen allowing you to "always
trust" checkbox.
Works for me on Windows XP SP2(as well as SP1)
Gord Dibben Excel MVP
On Mon, 19 Dec 2005 00:40:02 -0800, "Judy"
wrote:
In exercise 7, of create a certificate and use it to sign, it tells me to
add my certificate as a trusted publisher. When I follow the steps to do this
I don't get a security warning. Why is that?