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" <(E-Mail Removed)> wrote in message
news:70706D1A-125E-4987-A7B9-(E-Mail Removed)...
> 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