Sheet unprotect error

[sassriverrat]

My workbook just started throwing a random unprotect error when opening. I isolated the line of coding and tried running it by itself in a test sub and it failed then too.

The sheet is called "Developer"
Cells B15:E15 (merged) contain the password.
I have another sub that references this same password and works flawlessly.
Error is a 1004 - Application or Object defined error.

Sub test()
Sheets("Developer").Unprotect Password:=Worksheets("Developer").Range("B15:E15").Value, UserInterfaceOnly:=True
End Sub

 

[MARK858]

Have you tried .Range("B15").Value rather than .Range("B15:E15").Value

 

[RoryA]

Unprotect only has one argument - the password.

 

[sassriverrat]

Meaning I don't have to put in "password" in that line of coding?

 

[MARK858]

No Rory means the UserInterfaceOnly:=True shouldn't be there

 

[sassriverrat]

Oh right right. That's defining when it's protected but doesn't matter when coming off because you're taking it off....duh haha sorry! Thank you!

 

[sassriverrat]

Perfect. We seem to be back in business!