Posted to microsoft.public.excel.programming
|
|
Password To Run Macro?
This works like a charm! Exactly what I was looking for!
Thanks,
Valerie
"Nigel" wrote:
Before your code runs, ask the user for an input, simplest to use an
InputBox then validate the entry against a stored value (password)
simple example......
If InputBox("Enter password to run") < "MyPassword" Then
MsgBox "Wrong password"
Exit Sub
End If
' rest of your code
--
Regards,
Nigel
"garyh" wrote in message
...
Is there a way to request a password when a macro button is clicked? I
would like to 'lock' down the macros.
Thanks.
G
|