Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unlocking range of cells/worksheet?
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/vi.../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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unlocking range of cells/worksheet?
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 "DJone" wrote: 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/vi.../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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking/Unlocking cells upon condition | Excel Discussion (Misc queries) | |||
Unlocking protected cells | Excel Worksheet Functions | |||
Unlocking cells | Excel Worksheet Functions | |||
conditional unlocking of cells | Excel Worksheet Functions | |||
Unlocking Cells when a worksheet is protected... | Excel Discussion (Misc queries) |