ermccarthy
Board Regular
- Joined
- Feb 15, 2002
- Messages
- 224
I have a macro, that I want to run if the input in the userform is correct (password).
The below macro is a simple one that I do not want to execute unless the password inputted is correct....my problem is...I do not know how to do this, I wrote the macro, and created the userform and it seems to be working ok but how do I "capture the input" and run a comparison to what the password will be in the programming....any ideas.
UserForm1.Show
Range("A3:H53").Select
Range("B3").Activate
Selection.Locked = True
Range("E6").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, Password:="wsr"
Range("F7").Select
The below macro is a simple one that I do not want to execute unless the password inputted is correct....my problem is...I do not know how to do this, I wrote the macro, and created the userform and it seems to be working ok but how do I "capture the input" and run a comparison to what the password will be in the programming....any ideas.
UserForm1.Show
Range("A3:H53").Select
Range("B3").Activate
Selection.Locked = True
Range("E6").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, Password:="wsr"
Range("F7").Select