password protecting a macro button

You would have to use an InputBox to get the password and match the input to your passwoord

Dim the input as usual, then something along the lines of

If MyInput = "password" then
do something
Else do something else

End if

Create a name with the constant value of Your password then You refer to the name instead to it's value.

Steve,

How about

Dim strPassword As String
strPassword = InputBox("Password", "ENTER PASSWORD")
    If strPassword = "" Then Exit Sub
        If strPassword <> "Secret" Then
          MsgBox "Incorrect Password"
          Exit Sub
       End If
'YOUR CODE HERE

Then password protect the VBE, Tools>VBAProject Properties - Protection. This will take effect when you save, close and re-open.

If you need to hide the password while being typed, you will need to use a UserForm and a TextBox, with the TextBox PasswordChar Property set to *