Determining programmatically if a project is digitally signed

[Barb Reinhardt]

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

 

[Bernie Deitrick]

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/excel/HP030846111033.aspx

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

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

HTH,
Bernie
MS Excel MVP