I'm trying to find out in code not just whether ThisWorkbook has been signed (by checking the .HasVBproject and .VBASigned booleans), but who signed it. After all, one of our clients might themselves get a certificate and sign one of our artifacts, so a security check based on just a signature's presence would fail.
But if I open a signed workbook (XLSM) and examine its ThisWorkbook object, I see that .Signatures.Count is zero, just like an unsigned workbook! So how would I find out any signature's details, for example, the company name?
But if I open a signed workbook (XLSM) and examine its ThisWorkbook object, I see that .Signatures.Count is zero, just like an unsigned workbook! So how would I find out any signature's details, for example, the company name?