Sheet protection - passwords

[ElvisSteel]

Hi
I have the following macro...
Sub ProtectSheets()
Sheets("Outlook").Protect EnableSelection = xlNoSelection
Sheets("FY Utilisation Report").Protect EnableSelection = xlNoSelection
Sheets("Resource Check").Protect EnableSelection = xlNoRestrictions
Sheets("Project").Protect
Sheets("Reports 1").Protect EnableSelection = xlNoSelection
Sheets("Reports 2").Protect EnableSelection = xlNoSelection
Sheets("Tables").Protect
Sheets("Input").Protect
End Sub

When I run this, all of these are protected, but when I try to unprotect them (using the ribbon button) all of the sheets where I have specified xlNoSelection now require a password!
I don't know what the password is, so I am basically stuck.
Any ideas as to....
1. Why this is happening?
2. What the password may be?

Thanks

 

[Andrew Poulsom]

MsgBox EnableSelection = xlNoRestrictions
returns TRUE

For me in Excel 2000 that's the sheet's password. I don't know why it would be different in Excel 2007.

 

[ElvisSteel]

OK sorry - I was looking in the wrong place.

Thanks again for all your help