#1
|
|||
|
|||
Prompt for digital signature
Hi,
I have a Word template that contains a digital signature line added by Insert -> Signature line -> Microsoft Office Signature Line. The template is of course NOT signed. The user will enter data, and finally submit the document by pressing a macro button. The button does stuff like
I want to prompt the user to digitally sign the document if that hasn't already happened. I can reference SIGNED signature-lines. How can I reference UNSIGNED signature lines? I can create a NEW signature line and sign it with Code:
ActiveDocument.Signatures.AddSignatureLine.Sign vardelsuggsigner:="Name of the user", vardelsuggsignerline2:="Engineer (job title)", varsigimg:="John", vardelsuggsigneremail:="John@doe.com" Then the sign method kicks in: The resulting signature looks good, ignoring what the user entered earlier: I want to prepare a signature-line with details, so my users fill in as little as necessary. Who can help me to reference the UNSIGNED signature line? Then the macro should do something like Code:
ActiveDocument.SignatureLines(1).Sign |
#2
|
||||
|
||||
This is an interesting conundrum on something I haven't ever explored in Word.
I found a clue on ExcelForum by a user called marvinparanoidandroid which greatly helps. Unfortunately you will likely be required to create a free account there to see his answer. Can you try this code on your document? Code:
With ActiveDocument.Signatures .Subset = msoSignatureSubsetSignatureLinesUnsigned If .Count > 0 Then 'at least one unsigned signature in doc .Item(1).Sign End If End With
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
Tags |
signatureline |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
macOS Digital signature in excel | ki_ha1984 | Excel | 0 | 10-05-2019 05:31 AM |
Timestamp information in digital signature? | Tuuska | Word | 0 | 10-11-2018 06:41 AM |
an easy way to attach digital signature | erikrn | Outlook | 3 | 09-13-2015 11:46 AM |
Digital Signature | Alkaufmann | Word | 2 | 05-28-2015 04:22 PM |
Digital Signature invalidates all others? | JCWrs | Word | 0 | 03-08-2013 04:33 AM |