[Talk] Password Security in VB and VBA

[Rich McNeil]

About password security in VB and VBA...in VB...scripts can be secured by compiling them and VBA files can be locked with a password.  This doesn’t prevent viewing the file image in a text editor and possibly distinguishing a password there.   Entering the password string, say "ABCD", can be hidden with a simple Xor encryption such as:         Enter Crypt("05&6")   Where Crypt is:         Function Crypt(ByVal PW As String) As String       Dim i As Integer       Const CODE = "qwertyasdfjklqweru"           For i = 1 To Len(PW)               Mid(PW, i, 1) = Chr(Asc(Mid(PW, i, 1)) Xor Asc(Mid(c, i, 1)))           Next           Crypt = PW       End Function   and "05&6" is equal to Crypt("ABCD").       Rich McNeil Boston Software Systems 866 653 5105 www.bostonworkstation.com