Determining programmatically if a project is digitally signed

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

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
 
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
 
Back
Top