获取EXCEL2010文件写保护密码的方法（获取Excel密码）

shamofeiou

有时候大家会碰到excel的部分区域被保护，无法查看修改，读取公式等，但是又想不起密码，怎么办？
通过下面的方法，我们可以轻松获取excel工作簿写保护密码：

1. 新建宏 命名为：PasswordBreaker
2. 打开编辑宏，用下面的内容替换

1. Sub PasswordBreaker()
   
2. Dim i As Integer, j As Integer, k As Integer
   
3. Dim l As Integer, m As Integer, n As Integer
   
4. Dim i1 As Integer, i2 As Integer, i3 As Integer
   
5. Dim i4 As Integer, i5 As Integer, i6 As Integer
   
6. On Error Resume Next
   
7. For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
   
8. For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
   
9. For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
   
10. For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    
11. ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
    
12. Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
    
13. Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    
14. If ActiveSheet.ProtectContents = False Then
    
15. MsgBox "One usable password is " & Chr(i) & Chr(j) & _
    
16. Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
    
17. Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    
18. ActiveWorkbook.Sheets(1).Select
    
19. Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _
    
20. Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
    
21. Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    
22. Exit Sub
    
23. End If
    
24. Next: Next: Next: Next: Next: Next
    
25. Next: Next: Next: Next: Next: Next
    
26. End Sub

复制代码

3. 运行宏 PasswordBreaker， 即可获取密码。

中石油建设hy

直接vba编辑器里复制这个代码就行了 不用录制的

动力火车

谢谢楼主的分享