Thread: SelfCert
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ben Griffiths[_2_] Ben Griffiths[_2_] is offline
external usenet poster
 
Posts: 2
Default SelfCert

Thomas, thank you very much for this utility it allowed my to re-sign my VBA
projects.

This morning VBA reported "there was a problem with my digital signature and
it will be discarded". It was fine yesterday...today SelfCert.exe can't
create a new signature. I'm on a Novell network as you mentioned???

To be able to use the new signature created with your spreadsheet in my VBA
projects I had to delete two files from my PC first (they look like
hexadecimal keys):

1. The file in this directory
C:\Documents and Settings\%UserName%\Application
Data\Microsoft\SystemCertificates\My\Certificates

2. This whole directory
C:\Documents and Settings\%UserName%\Application
Data\Microsoft\SystemCertificates\My\Keys

I also went into the Certificates section of Internet Options and deleted
any reference to my old digital signature name. I was then able to save my
VBA projects with the new signature attached and mark it as a trusted source.

Thanks again
Ben



"Thomas Ramel" wrote:

Grüezi Demetrius

schrieb am 01.02.2005

[SelfCert problems snipped]

Can somebody clarify for me what may have caused this and some possible
solutions?


Selfcert has some problems with its GUI - it seems connected with Novell
netware.

I once wrote a little excelfile (in German unforunately) that creates new
certificates if the 'official way' fails.
You can download it here - just push the button on the sheet and tyope your
name:

http://users.quick-line.ch/ramel/Fil...t_ersetzen.XLS



Regards
Thomas Ramel

--
- MVP for Microsoft-Excel -
[Win XP Pro SP-2 / xl2000 SP-3]