Is it possible to password protect a button?

[Randal G]

I have a button of which activates a macro to reset a work calculations calendar. It is important that I don't accidentally click the button till its time. I could just set it up manually enter the variable that would handle the resetc(which is what I had), but the button would be nice if I could just password or otherwise protect it.
If this is a VB solution... go easy on me. It's my short coming.
Thanks to any solutions
Randal G.

 

[Sambu]

Re: WELCOME TO THE BOARD!

How about...

Thank you. It works

 

[Fluff]

Re: WELCOME TO THE BOARD!

Glad to help & thanks for the feedback

 

[Sambu]

Re: WELCOME TO THE BOARD!

Hello, now box haven't any reaction when i click cancel. Could you help? I want to exit password box if i filled data wrong by cancel.

 

[Fluff]

Re: WELCOME TO THE BOARD!

Try

Sub Pword()

    Dim Ans As Variant
    Const Pword As String = "Zebra"
    
    Do While Ans <> Pword
        Ans = Application.InputBox("Please enter password to continue.", "Enter Password")
        If Ans = Pword Then Exit Do
        If Ans = False Then Exit Do
     Loop

End Sub