Quote:
Originally Posted by excelledsoftware
Interesting. The ActiveSheet.Unprotect Password:"Test"
works just fine for me. There are 2 things you can try. First ensure that "Test" is indeed suppose to be capitaized. next you could try creating a variable and then using that for the password.
Code:
dim pass as string
pass = "Test"
ActiveSheet.Unprotect Password: pass
|
That didn't work for me either.