View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default See digital signature timestamp for workbook with trusted cert

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