Create/install a "certificate in the trusted Root Certification Authorities store"

[EagleOne]

XP Pro up to date


using (from START>RUN) certmgr.msc I found a certificate that I would like to
install it in "the trusted Root Certification Authorities store".

I can see the certificate in the Personal folder but its "certification path" indicates
that it is "Not Trusted."

Do I have to delete it and start over? modify it?

The certificate was to authorize my personal Macros in Excel. That said, I do
not believe it is an Excel issue (creating, modifying, installing certificates)

I have no clue how to:
1) create a personal certificate and/or
2) install it in the trusted Root Certification Authorities store and/or
3) make sure that the "certificate path" is OK (in short authorized and OK)

Please help!

EagleOne

 

[Michael Yardley]

XP Pro up to date

using (from START>RUN) certmgr.msc I found a certificate that I would liketo
install it in "the trusted Root Certification Authorities store".

I can see the certificate in the Personal folder but its "certification path" indicates
that it is "Not Trusted."

Do I have to delete it and start over?  modify it?

The certificate was to authorize my personal Macros in Excel.  That said, I do
not believe it is an Excel issue (creating, modifying, installing certificates)

I have no clue how to:
1)  create a personal certificate and/or
2)  install it in the trusted Root Certification Authorities store and/or
3) make sure that the "certificate path" is OK (in short authorized and OK)

Please help!

EagleOne

Where do you get your own security certificates?
Security certificates are issued by independent certification
authorities. There are different classes of security certificates,
each one providing a different level of credibility. You can obtain
your personal security certificate from certification authorities

http://windowshelp.microsoft.com/Wi...a658-27cd-4749-a41d-3e6ef3eb268b1033.mspx#ESC

Certificate authority
http://en.wikipedia.org/wiki/Certificate_authority

Internet Options Content Certificates.

 

[EagleOne]

It was my understanding that one could create a "personal" certificate for Excel Macros that one
creates. I did that, and the certificate was put into the Personal Certificates folder of
"certmgr.msc".

That said, the Certification Path indicates that it is "not trusted."

Further the information provided states the to be Trusted that I must:

install it in "the trusted Root Certification Authorities store".

 

[EagleOne]

For those interested in this issue read the following:

Gord Dibben MS Excel MVP

Instructions for Excel 2003 on WindowsXP Pro SP2

Have a go at changing the DC to a Trusted Certifiicate.

With Excel closed......................

Start>Run "mmc" to open the Microsoft Management Console.

File>Add/Remove Snap-in. Select Certificates snap-in.

*********** At this point I was not provided the option mentioned in your next step

Expand and open Personal Certificates folder.

Select your SelfCert DC and drag it to the Trusted Root
Certificates>Certificates folder.

Close MMC...........you can save changes to Comsole1.msc if you choose, but not
necessary unless you want the snap-in to stay loaded.

Now open Excel and your workbook.

Any difference?


Gord Dibben MS Excel MVP

Gord,

I was not able to continue the mmc process mentioned past *********** above.
That said, I would like to know what I did wrong.

I did open (via Start>Run) certmgr.msc

In that utility, I was able to drag my certificate to
the "Trusted" folder and it is now "Trusted" when I look at the "Certificate path"

Thanks Gord (if you have the time what did I do wrong with mmc?)