LinkBack URL
About LinkBacks
I am using Microsoft Office 2013.
I have a number of Excel and Word documents all of which contain a number of signature blocks.
I want to be see which signature blocks have been signed and which ones have not been signed.
My problem is that in the simplified VBA code below Signatures.Count only returns the number of SIGNED blocks.
How do I get data from both signed and unsigned signature blocks.
Sub getsigdata()
Dim signer As String
countsigs = ActiveDocument.Signatures.Count
If countsigs > 0 Then
For i = 1 To countsigs
signer = ActiveDocument.Signatures.Item(i).Setup.SuggestedSigner
MsgBox (signer)
Next i
End If
End Sub
Register To Reply
Bookmarks