油氣儲(chǔ)運(yùn)網(wǎng)

標(biāo)題: 獲取EXCEL2010文件寫保護(hù)密碼的方法（獲取Excel密碼） [打印本頁(yè)]
作者: shamofeiou    時(shí)間: 2014-10-9 21:24
標(biāo)題: 獲取EXCEL2010文件寫保護(hù)密碼的方法（獲取Excel密碼）
有時(shí)候大家會(huì)碰到excel的部分區(qū)域被保護(hù)，無法查看修改，讀取公式等，但是又想不起密碼，怎么辦？
通過下面的方法，我們可以輕松獲取excel工作簿寫保護(hù)密碼：

1. 新建宏 命名為：PasswordBreaker
2. 打開編輯宏，用下面的內(nèi)容替換

  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
復(fù)制代碼
3. 運(yùn)行宏 PasswordBreaker， 即可獲取密碼。



作者: 中石油建設(shè)hy    時(shí)間: 2014-10-10 02:46
直接vba編輯器里復(fù)制這個(gè)代碼就行了  不用錄制的
作者: 動(dòng)力火車    時(shí)間: 2022-6-8 11:15
謝謝樓主的分享



歡迎光臨 油氣儲(chǔ)運(yùn)網(wǎng) (http://black-hills-tours.com/) Powered by Discuz! X3.4