Hey all..
I've got this code protecting my macro button. It works but bypasses and runs through and resets my excel sheet what the macro was built to do. In the case of an incorrect password it should end but doesn't.
Where did I go wrong? Help is much appreciated..
Private Sub CommandButton1_Click() Dim password As Variant password = Application.InputBox("Enter Password", "Password Protected") Select Case password Case Is = False 'do nothing Case Is = "reset" Range("A3").Value = "This is secret code" Case Else MsgBox "Incorrect Password" End Select
Regards Pius
Bookmarks