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/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