Password Protect A Macro Button

[MIRPAX]

I have a worksheet that I only want certain users running the VBA code. I would like to somehow password protect the macro button so that only selected users can run it. Is this possible?

 

[MattH1]

Using the information from: Password Protect Excel Macro - EASY Excel VBA
You can set up a code at the beginning of your macro to prompt you for a password.
The code is below:

Dim password As Variant
              password = Application.InputBox("Enter Password", "Password Protected")

Select Case password
                  Case Is = False
                      'do nothing
                  Case Is = "PASSWORD" 'Edit this line with the password you wish to protect your macro with.
                      'This is where your code will go.
                  Case Else
                      MsgBox "Incorrect Password"
End Select

Edit: If you want to lock it from viewing and editing (so that they can't change the password in the coding or figure out the password and use it), please refer to the thread I linked above.

Hope this answers your question!

 

[My Aswer Is This]

Show us the script in your button.
We can provide some protection but a determined user with enough knowledge can do most anything with excel.

 

[MIRPAX]

MattH1 - This is exactly what I was looking for. Thank you for your sharing your knowledge so quickly!

 

[MattH1]

MattH1 - This is exactly what I was looking for. Thank you for your sharing your knowledge so quickly!

Glad to be of assistance! Have a nice day.