Password To Run Macro?
Hi,
You could put this as the first lines of your code which gives you 3 chances
to enter the corrrect case sensitive password. It isn't secure because the
passwoord is visible when entered but even if you use a userform textbox to
mask the passowrd that isn't secure either
Do
response = InputBox("Enter password", "Run Macro")
If response < "Mypass" Then
x = x + 1
If x 2 Then Exit Sub
Else
MsgBox "Running macro"
Exit Do
End If
Loop
'your code
Mike
"garyh" wrote:
Is there a way to request a password when a macro button is clicked? I
would like to 'lock' down the macros.
Thanks.
G
|