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