Password issues on Workbook Open Event

[quackdad]

When I run this code I get a message that the password is incorrect. But it is correct. Do I need to state it another way?

Private Sub Workbook_Open()
    Sheets("Employees").Unprotect Password = "Password"
    Range("F8").Select
    Sheets("Employees").Protect Password = "Password"
End Sub

 

[royUK]

There must be an error with the password spelling or case, because there is no problem with the code.

 

[RoryA]

Actually, the code is wrong. You're passing False as the password. It should be:

Private Sub Workbook_Open()
    Sheets("Employees").Unprotect Password:="Password"
    Range("F8").Select
    Sheets("Employees").Protect Password:="Password"
End Sub

Note the colons!

 

[royUK]

Should have used my eyes Rory I didn't notice the missing :.

 

[RoryA]

I'd be lying if I said I'd never done it!

 

[quackdad]

Thanks to both!
To ensure accuracy, I copy and paste when it comes to passwords (that's how I knew the password was correct). But then I tried to create the rest of the formula from scratch. If only I'd been lazier at that point ....

 

[royUK]

Just go with

Private Sub Workbook_Open()   
 Sheets("Employees").Unprotect "Password"   
 Range("F8").Select    
Sheets("Employees").Protect "Password"
End Sub

 

[quackdad]

Simple is good - Thanks, royUK

 

[RoryA]

Of course, I should have just shamelessly self-promoted and pointed you here: Excel Matters » Blog Archive » What’s in a colon?

 

[quackdad]

Of course, I should have just shamelessly self-promoted and pointed you here: Excel Matters » Blog Archive » What’s in a colon?

I checked it out, and now I feel compelled to ask:
What, is any, is the difference between
.Unprotect Password:="Password"
and
.Unprotect Password "Password"