M
MSweetG222
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.
#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.