Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login
Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Tek-Tips LinkedIn® Group

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...If there has ever been a justification needed for access to the net during working hours, just referring to this site should suffice. Fantastic!..."
More...

Geography

Where in the world do Tek-Tips members come from?
Click Here To Find Out!

Tek-Tips Shirts!

Get Tek-Tips Swag
Get your
Tek-Tips Forums
SWAG here!
Home > Forums > Programmers > Languages > VBA Visual Basic for Applications (Microsoft) Forum

Excel 2010 Password Protection Issues - What is Protected View?Helpful Member! 

thread707-1690071
Read More Threads Like This One
shelby55 (TechnicalUser)
6 Aug 12 11:16
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 (Programmer)
6 Aug 12 11:31
hi,

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

http://office.microsoft.com/en-us/excel-help/what-...

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

shelby55 (TechnicalUser)
6 Aug 12 11:38
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".

CODE

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 (Programmer)
6 Aug 12 11:46
So what password did you attempt to apply, that was rejected?

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

shelby55 (TechnicalUser)
6 Aug 12 12:38
Jbhproject
Helpful Member!  SkipVought (Programmer)
6 Aug 12 12:47

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

CODE

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,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

shelby55 (TechnicalUser)
6 Aug 12 13:21
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 (Programmer)
6 Aug 12 13:30
I see that you...

CODE

The
          
Lines
upsidedown

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

Read More Threads Like This One

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To VBA Visual Basic for Applications (Microsoft)

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close