Is it possible to protect the code?

Wilker12 · Feb 19th 2019

Hello,

I've seen several scripts to check out spreadsheets...
Is it possible to protect the VBA source code from view?

Thanks.

rabsofty · Feb 19th 2019

yes in VBA right click on your project and select it's properties.
There you can password protect your code form being viewed

jl2509 · Feb 19th 2019

Hi,

Using the standard protection in excel is not very secure and is easily overcome with a little know ho or an off the shelf product for password recovery.
There are methods to protect your hard work but come at a price.

Take a look at the link below for some explanations and a potential solution.

https://www.thespreadsheetguru…oject-password-protection

hope this helps

Wilker12 · Feb 25th 2019

Interesting, jl2509. Thank you.

jl2509 · Feb 26th 2019

Happy to help

Thanks for the like

Gerw2 · Dec 12th 2019

Work well!

FrankM · Dec 12th 2019

I don't know if you found a solution. Here what I have used,

Code

Option Explicit
Sub Admin()
Dim strPassTry As String
Dim strPassword As String
Dim lTries As Long
Dim bSuccess As Boolean

strPassword = "Password" 'Change to you own password
   For lTries = 1 To 3 'Change the number of tries to what ever you want.
    strPassTry = InputBox("Enter Password Please", "Administrative Access Only!")
        If strPassTry = vbNullString Then Exit Sub
        bSuccess = strPassword = strPassTry
        If bSuccess = True Then Exit For
         Application.Speech.Speak "   HEY!!!   You have not made a valid entry.  Please try again.  ", SpeakAsync:=True
            Application.Wait (Now + TimeValue("00:00:06"))
        MsgBox "Password Incorrect!!" & vbNewLine _
        & vbNewLine & "Please enter correct Password!!!" & vbNewLine _
        & vbNewLine & "Or ask for administrative assistance!!!"
    Next lTries
 
    If bSuccess = True Then
    Application.VBE.MainWindow.Visible = True
    End If
End Sub

Display More

**royUK** · Dec 13th 2019

Frank, that will not protect the code.

Even workbook protected with Unviewable can be cracked.

Standard VB Editor protection will deter most users.

Is it possible to protect the code?

Participate now!

Share