Decreenisi said:
I have an excel workbook which has a lot of code written to automated
tasks. However the codes now need some housekeeping. The only problem
is the author is no longer with us and they have passworded the sheets
as well as the workbook as a whole. Is there anyway round this dilema,
or do we have to start from scatch.
I can't vouch for whether this works, since I've never needed to use it,
but here's a routine I got from a newsgroup in 2004:
Make the sheet you want to remove the protection from the active sheet and
then run this subroutine.
It will "come" back with teh message that an password is found. Click OK
and the protection from the sheet will be removed.
Sub PasswordBreaker_Sheet()
'Author unknown
'Breaks worksheet password protection.
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
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 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
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
Bill
