Hi there
I have this code to protect and un-protect a worksheet
ActiveSheet.Unprotect Password = "test"
Code goes here
.
.
.
ActiveSheet.Protect Password = "test"
End Sub
Here is the problem. When I run the code, it runs just fine. But when I manually try to un-protect the worksheet I get the usual pop up to enter my password. When I enter my password "test" without the quotes I get a pop up that says "The password you supplied is not correct......" But id did supply the correct password. So what did I do wrong??
I have this code to protect and un-protect a worksheet
ActiveSheet.Unprotect Password = "test"
Code goes here
.
.
.
ActiveSheet.Protect Password = "test"
End Sub
Here is the problem. When I run the code, it runs just fine. But when I manually try to un-protect the worksheet I get the usual pop up to enter my password. When I enter my password "test" without the quotes I get a pop up that says "The password you supplied is not correct......" But id did supply the correct password. So what did I do wrong??