Hello all,

#1 - Is there vba code to tell if a workbook is [Signed, unverified] or is
[Signed, verified]?

I can see it in the window caption (Microsoft Excel - MyTest.xls [Signed,
unverified]), but I don't know how to capture in vba.

I am writing an addin and I would like to check this status (to make sure no
one changed the worksheet since the digial signature was added) before the
addin utilizes data on the worksheet.

I found the code to check the digital signature of the VBA project, but not
this. I see Word has SignatureSet, but I can't seen to locate anything
similar in Excel.

#2 - how does one save the workbook to make the window caption say "[Signed,
verified]"? What do I do to verify it?

Any help would be greatly appreciated. thx.

--
Thx
MSweetG222