S
Stan Brown
(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?
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?