Hi All!

I'm signing my VBA code with a digital certificate from Thawte.
I have set my machine up to timestamp the signature by using
Verisigns timestamoing server. My Excel is set up to trust
workbooks with my own certificate.

HOW can I see when one of my workbooks was signed/timestamped?
I can see this information when opening a workbook with an nontrusted
certificate, by clicking "Details" in the "Security warning" dialog. But I
don't know how to see this information for a workbook with a trusted
certificate.

Ture Magnusson
Karlatad, Sweden

Any of these help:

View certificates for a file

On the Tools menu, click Options.
Click the Security tab.
Click Digital Signatures.
To view details about a particular certificate, select the name of the
signer, and then click View Certificate.
View certificates for a macro project

If your Macro Security setting is set to Medium or High, you will receive a
warning before you open files that contain macros signed with suspicious
certificates. The warning dialog box allows you to click Details to view the
properties of the certificate.

***To view certificates for a file that you already have open, follow these
steps: ***

On the Tools menu, point to Macro, and then click Visual Basic Editor.
Use the project explorer to select the desired macro project.
In the Visual Basic Editor, click Digital Signature on the Tools menu.
In the Digital Signature dialog box, click Detail to view the details of the
certificate.
Note The Detail button will only appear if a digital certificate is
attached to the project.

--
Regards,
Tom Ogilvy



"Ture Magnusson" wrote in message
...
Hi All!

I'm signing my VBA code with a digital certificate from Thawte.
I have set my machine up to timestamp the signature by using
Verisigns timestamoing server. My Excel is set up to trust
workbooks with my own certificate.

HOW can I see when one of my workbooks was signed/timestamped?
I can see this information when opening a workbook with an nontrusted
certificate, by clicking "Details" in the "Security warning" dialog. But I
don't know how to see this information for a workbook with a trusted
certificate.

Ture Magnusson
Karlatad, Sweden

Tom,

Thanks, but... I was already aware of these ways to see a certificate.

But, if I'm not totally blind, none of these methods allow me to see the
date and time when the project was signed/timestamped. I haven't found
a way to see this informtaion for a workbook which is signed with a
certificate which I have chosen to trust.

Still in the dark...
/Ture


"Tom Ogilvy" wrote in message
...
Any of these help:

View certificates for a file

On the Tools menu, click Options.
Click the Security tab.
Click Digital Signatures.
To view details about a particular certificate, select the name of the
signer, and then click View Certificate.
View certificates for a macro project

If your Macro Security setting is set to Medium or High, you will receive
a
warning before you open files that contain macros signed with suspicious
certificates. The warning dialog box allows you to click Details to view
the
properties of the certificate.

***To view certificates for a file that you already have open, follow
these
steps: ***

On the Tools menu, point to Macro, and then click Visual Basic Editor.
Use the project explorer to select the desired macro project.
In the Visual Basic Editor, click Digital Signature on the Tools menu.
In the Digital Signature dialog box, click Detail to view the details of
the
certificate.
Note The Detail button will only appear if a digital certificate is
attached to the project.

--
Regards,
Tom Ogilvy



"Ture Magnusson" wrote in message
...
Hi All!

I'm signing my VBA code with a digital certificate from Thawte.
I have set my machine up to timestamp the signature by using
Verisigns timestamoing server. My Excel is set up to trust
workbooks with my own certificate.

HOW can I see when one of my workbooks was signed/timestamped?
I can see this information when opening a workbook with an nontrusted
certificate, by clicking "Details" in the "Security warning" dialog. But
I
don't know how to see this information for a workbook with a trusted
certificate.

Ture Magnusson
Karlatad, Sweden