View Single Post
 
Old 03-16-2015, 05:53 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You can certainly insert the username, time and date into a document using VBA, though it would have no security value.

Code:
Sub InsertNameAndDate()
    Selection.TypeText Environ("UserName") & Chr(32) & Chr(150) & Chr(32) & _
                       Format(Date, "Long Date") & Chr(32) & Chr(150) & Chr(32) & _
                       Format(Time, "HH:MM")
lbl_Exit:
    Exit Sub
End Sub
You could include a scanned signature graphic, but that would not improve security either, and you would need to arrange a selection of images one for each user.

This is not a substitute for digitally signing a document.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote