Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get the security warning, add myself as trusted publisher
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get the security warning, add myself as trusted publisher
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How turn off macro security question for workbook with no marcos? | Excel Discussion (Misc queries) | |||
How to disable Security Warning for Excel 2003 with NO macros | Setting up and Configuration of Excel | |||
how to raise the Macro security level in a product I can't execute | Excel Discussion (Misc queries) | |||
Formulae, conditional formatting & macro security | Excel Discussion (Misc queries) |