Excel 2010 Password Protection Issues - What is Protected View? 1

[shelby55]

Hello

I'm trying to use password to protect my worksheets and if I enter the password as "password" then it works fine. But if I change and use something else then I get the message "the password you supplied is not correct. Verify that the CAPS lock key is off and be sure to use the correct capitalization."

I've changed the password numerous times and even copied and pasted it when prompted but still get the same error. I read that it may be related to the Protected View in Office 2010 but can't seem to find out how to get around it.

Any and all assistance greatly appreciated.

 

[SkipVought]

hi,

Protected View seems to have nothing to do with Sheet Protection.

http://office.microsoft.com/en-us/excel-help/what-is-protected-view-HA010355931.aspx

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[shelby55]

Hi

Thanks Skip...but then any idea why it's not working? To see about fixing some of the issues I'm having with protect and unprotect on the other thread, I followed Hoaokapohaku's advice and added the protect/unprotect as a Workbook_Open event. So after I've run the abstracts and saved the document then everything is locked as I wish and the code is only in one place.

But, as mentioned, I get an error if I use anything other than "password".

Private Sub Workbook_Open()
Dim wSheet As Worksheet
For Each wSheet In Worksheets
wSheet.Protect Password:="password", userinterfaceonly:=True
wSheet.Range("J5:J37").Locked = False
Next wSheet

End Sub

So when I open up the document and the password is applied (if not "password") then I get the error message of "the password you supplied is not correct. Verify that the CAPS lock key is off and be sure to use the correct capitalization." I was using punctuation and numbers in the original but even just changing to all text doesn't fix the problem. Any ideas?

 

[SkipVought]

So what password did you attempt to apply, that was rejected?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[shelby55]

Jbhproject

 

[SkipVought]

Ran no problem in 2007, starting with UNPROTECTED SHEETS..

Private Sub Workbook_Open()
    Dim wSheet As Worksheet
    For Each wSheet In Worksheets
        wSheet.Protect Password:="Jbhproject", userinterfaceonly:=True
        wSheet.Range("J5:J37").Locked = False
    Next wSheet

End Sub

I see nothing in 2007-2010 change comparisons that would indicate a change in sheet protection.



Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[shelby55]

Hi

That was it, it was starting as protected so I had to unprotect everything, save like that including the workbook_open event and now it's fine.

Thanks for your help.

 

[SkipVought]

I see that you...

 The
[highlight red]     [/highlight]     
Lines

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]