"There was a problem with the digital certificate. The VBA project could not be signed. The signature will be discarded."

[Rick]

I have signed VBA projects in Excel 2007 and Access 2007 with my digital
certificate created with MS Office SelfCert. Initially everything worked
fine. But if I alter the VBA code in a particular project and then re-sign
the code I receive the following error upon saving: "There was a problem
with the digital certificate. The VBA project could not be signed. The
signature will be discarded."

My digital certificate is presently installed in the following "my user
account" certificate stores: Personal; Trusted Root Certification
Authorities; Trusted Publishers; and Trusted People.

Other VBA projects in both Excel and Access, which I have not recently
changed the VBA code, are still functioning properly. The Trust Center
Macro Settings in both Excel and Access is set to "Disable all macros except
digitally signed macros." I obviously do not want to enable all macros and
this setting has always worked in the past.

Also. if I attempt to create a new digital certificate or re-create my
original digital certificate with SelfCert I receive the following error
message: "An error occurred during certificate creation. SelfCert was unable
to create your certificate." It's as if SelfCert allows the creation of
only one digital certificate and then will not create another.

I believe I came across this same problem a few years back but have
forgotten how to resolve it and I can't find any good suggestions via
Google.

I would appreciate any help anyone may offer. Thank you VERY much in
advance.
Rick

[David Price]

Rick,

I am having the same problem with an authenticated certificate. Have you found a solution?

> On Tuesday, July 20, 2010 12:11 PM Rick wrote:

> I have signed VBA projects in Excel 2007 and Access 2007 with my digital
> certificate created with MS Office SelfCert. Initially everything worked
> fine. But if I alter the VBA code in a particular project and then re-sign
> the code I receive the following error upon saving: "There was a problem
> with the digital certificate. The VBA project could not be signed. The
> signature will be discarded."
>
> My digital certificate is presently installed in the following "my user
> account" certificate stores: Personal; Trusted Root Certification
> Authorities; Trusted Publishers; and Trusted People.
>
> Other VBA projects in both Excel and Access, which I have not recently
> changed the VBA code, are still functioning properly. The Trust Center
> Macro Settings in both Excel and Access is set to "Disable all macros except
> digitally signed macros." I obviously do not want to enable all macros and
> this setting has always worked in the past.
>
> Also. if I attempt to create a new digital certificate or re-create my
> original digital certificate with SelfCert I receive the following error
> message: "An error occurred during certificate creation. SelfCert was unable

> to create your certificate." it is as if SelfCert allows the creation of

> only one digital certificate and then will not create another.
>
> I believe I came across this same problem a few years back but have

> forgotten how to resolve it and I cannot find any good suggestions via

> Google.
>
> I would appreciate any help anyone may offer. Thank you VERY much in
> advance.
> Rick

> Submitted via EggHeadCafe - Software Developer Portal of Choice
> Changing WCF Service Implementation at Runtime
> http://www.eggheadcafe.com/tutorials/aspnet/d9263dcc-f7ed-42f3-bc96-321461be3306/changing-wcf-service-implementation-at-runtime.aspx