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

  • Thread starter Thread starter EagleOne@discussions.microsoft.com
  • Start date Start date
E

EagleOne@discussions.microsoft.com

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

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
 
Re: Create/install a "certificate in the trusted Root CertificationAuthorities store"

Re: Create/install a "certificate in the trusted Root CertificationAuthorities store"

On Mar 18, 8:11 am, Eagle...@discussions.microsoft.com wrote:
> 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

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.
 
Re: Create/install a "certificate in the trusted Root Certification Authorities store"

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

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".


Michael Yardley <middleton@mail.org> wrote:

>On Mar 18, 8:11 am, Eagle...@discussions.microsoft.com wrote:
>> 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
>
>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.
 
Re: Create/install a "certificate in the trusted Root Certification Authorities store"

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

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?)
















Michael Yardley <middleton@mail.org> wrote:

>On Mar 18, 8:11 am, Eagle...@discussions.microsoft.com wrote:
>> 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
>
>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.
 
Back
Top