Password protect a macro (1 Viewer)

[jason2885]

I have a button in a form that runs a macro. I need to somehow password protect that button. How could I go about doing that.

 

[pbaldy]

One way:

If InputBox(...) = "password" Then
  'run macro
Else
  Msgbox "Wrong password"
End If

See VBA Help for more info on InputBox if needed.