dcompagnone
Board Regular
- Joined
- Dec 14, 2007
- Messages
- 119
Hi Professionals!
I want to run a simple macro that enables me to unlock and lock all sheets at once with the same password through a single userform BUT that also requires that I put another form of identification in before it will run.
Simply, I have created a userform that asks me for two pieces of information, a pin number and a password.
I would like the pin number to be validated before the password is applied.
something along the lines of
PIN = 5555
Password = secret
'if textbox1.Value = "5555" and textbox2.value = "secret" then protect/unprotect all sheets using password.
Else MsgBox "Either your PIN or Password do not match, please check and try again."
I'd like the same code to run for protecting and unprotecting .
Help appreciated
Dominic
I want to run a simple macro that enables me to unlock and lock all sheets at once with the same password through a single userform BUT that also requires that I put another form of identification in before it will run.
Simply, I have created a userform that asks me for two pieces of information, a pin number and a password.
I would like the pin number to be validated before the password is applied.
something along the lines of
PIN = 5555
Password = secret
'if textbox1.Value = "5555" and textbox2.value = "secret" then protect/unprotect all sheets using password.
Else MsgBox "Either your PIN or Password do not match, please check and try again."
I'd like the same code to run for protecting and unprotecting .
Help appreciated
Dominic