Unlocking range of cells/worksheet?

[DJone]

Can not figure this out for the life of me.

At work here, there is a folder on the network with some Excel files. Three
people are trying to open up and edit these (One at a time, to my knowledge).

Person 1 and Person 2 can open up and edit all of the files in that network
folder, however, Person 3 can edit 3 out of the 5 files no problem. The other
2 files, if person 3 tries to edit them, gets a pop up box titled "Unlock
Range" "Enter the password to change this cell:" no matter what cell Person 3
tries to edit.

Doesn't matter if Person 3 tries to double click a cell, right click a cell
or try and edit the cell from the formula line, it always pops this box up. I
tried a few passwords and even tried pressing ok when it was blank, but to no
avail.

I even tried copying this file off of the network to my local computer, and
I get the same pop up box.

The file properties outside of Excel are not marked "Read only" or any other
attributes that would limit it.

I have checked everything possible that has to do with this problem
according to Microsoft's help, so I now turn to you guys.

Something interesting, under the Tools menu, then Protection, the option
titled "Allow Users to Edit Ranges..." is grayed out so I am not able to
select it, though this sounds like the exact option that I need. One of the
other options called "Unprotect worksheet" asks me for a password also, which
I have tried a few and leaving it blank too.

I can not get to edit these files except for on a select few employees
computers where I do not get any of these prompts at all!

This is so bizarre! Has anyone else had this problem? And found out a way to
fix it? I have uploaded a picture of some of the options I have already
checked to give you guys a better idea of what I have tried to do already.

The image is located at:
http://www.we-todd-did-racing.com/view/full/1005596_1sevm

Please help! If you guys need any more details, feel free to ask away. I
will try and check in every now and then to see the replies!

Thanks so much (In advance)! I appreciate it!

 

[James O]

When someone created this worksheet, they allowed the users to edit it
without a password. This is why some people can and some people can't edit
the document. If you don't know the password, one thing to try is to break
it. Put this code into VBA and run it. It should unlock the document.

Sub InternalPasswords()
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer


On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveWorkbook.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) _
& Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) _
& Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveWorkbook.ProtectStructure = False Then
If ActiveWorkbook.ProtectWindows = False Then
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) _
& Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) _
& Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
End If
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next

End Sub