Determining programmatically if a project is digitally signed
 

How would I do this programatically for a workbook. I can get to myWB (as
an object) or myVBProj (as a vb project for that workbook), so if you could
provide the syntax from there, I'd be most appreciative. Also, if it's
signed, I'd like to list the signature.

Thanks,
Barb Reinhardt

Determining programmatically if a project is digitally signed
 

Barb,

ActiveWorkbook.VBASigned

will return TRUE or FALSE

If you set your macro security level to High, only project signed by trusted
sources will open with macros enabled, I think(?)

Anyway, look at

http://office.microsoft.com/en-us/ex...846111033.aspx

for more - expand the article by clicking the + boxes....

I don't know how to list the signer....

HTH,
Bernie
MS Excel MVP


"Barb Reinhardt" wrote in message
...
How would I do this programatically for a workbook. I can get to myWB
(as
an object) or myVBProj (as a vb project for that workbook), so if you
could
provide the syntax from there, I'd be most appreciative. Also, if it's
signed, I'd like to list the signature.

Thanks,
Barb Reinhardt