Re: Problem with digital certificate

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Stan

I have the same DC's in both folders and see no negative effects.

If you double-click on the DC in your Personal Folder does it still have the big
red cross on it signifying not trusted?

Once moved to the Trusted Root folder that red cross should disappear.

I am still concerned about the second part of your original posting, that is the
part about

"An
error occurred during certificate creation. Selfcert was unable to
create your certificate." (exact text)

I don't understand that unless you are trying to create another selfcert DC with
the same name as your original.

Maybe an idea to open MMC and delete the selfcert DC from both folders and start
over building a new one.


Gord Dibben MS Excel MVP


On Sun, 1 Apr 2007 17:41:51 -0400, Stan Brown <the_stan_brown@xxxxxxxxxxx>
wrote:

Thanks, Gord.

Maybe this is the problem: the certificate shows up both in Personal
and in Trusted Root.

Should I delete one or both of them?

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/


Sun, 01 Apr 2007 09:25:49 -0700 from <Gord Dibben
<gorddibbATshawDOTca>>:
Stan

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.

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

On Sun, 1 Apr 2007 09:24:10 -0400, Stan Brown <the_stan_brown@xxxxxxxxxxx>
wrote:

(Office 2003 Professional)

I created a digital certificate for myself a few days ago, so that I
could sign my own macros and not get the macro warning when I open my
workbook. It worked fine for a few days, but now it's stopped
working.

The first symptom this morning was that when I opened my workbook a
message displayed my certificate name and something to the effect of
"You should not trust macros from this publisher". No problem, I
thought, I'll just re-sign the VBA.

When I tried that, the actual signing went fine but on saving the
workbook I got "There was a problem with the digital certificate. The
VBA project could not be signed. The signature will be discarded."
(exact text) When I closed and reopened the workbook, I got the macro
warning and when I checked I found the VBA was no longer signed.

I thought this might just be a problem with this workbook, so I did a
copy/paste of the VBA to a new workbook's VBA module. (I copied the
VBA by highlighting all the code and doing Ctrl-C, not by copying the
modules in the Explorer-style pane of the VB Editor.) Same problem:
I could sign the new book but got the above message on saving.

Okay, so I tried to create myself a new certificate. (Microsoft
Office Tools > Digital Certificate for VBA). This time I get "An
error occurred during certificate creation. Selfcert was unable to
create your certificate." (exact text)

Neither of those messages is very helpful about how to remedy the
problem. I've only signed two workbooks at this point, so I don't
mind starting over if that's the easiest way. Advice?

.

Relevant Pages

  • Re: Problem with digital certificate
    ... Sounds like the SelfCert process is gibbled somehow. ... "An error occurred during certificate creation. ... Now open Excel and your workbook. ... VBA project could not be signed. ...
    (microsoft.public.excel.misc)
  • Re: Problem with digital certificate
    ... SelfCert is an Office Tool not just confined to Excel. ... as admin and was able to create a certificate, ... Now open Excel and your workbook. ... VBA project could not be signed. ...
    (microsoft.public.excel.misc)
  • Problem with digital certificate
    ... I created a digital certificate for myself a few days ago, ... The first symptom this morning was that when I opened my workbook a ... "You should not trust macros from this publisher". ... VBA project could not be signed. ...
    (microsoft.public.excel.misc)
  • Re: Problem with digital certificate
    ... Productivity add-ins and downloadable books on VB macros for Excel ... I created a digital certificate for myself a few days ago, ... The first symptom this morning was that when I opened my workbook a ... VBA project could not be signed. ...
    (microsoft.public.excel.misc)
  • RE: Reference to closed workbook
    ... Let us know what you think about using VBA ... Each workbook is saved on a network G ... where alpha is the letters A-Z based on surname and each user under their ... respective alpha split folder has a foldername based on the following ...
    (microsoft.public.excel.misc)