油气储运网

 找回密码
 立即注册

QQ登录

QQ快速登录

一步迅速开始

pdms培训&项目数字化360网
查看: 7248|回复: 2

[学习教程] 获取EXCEL2010文件写保护密码的方法(获取Excel密码)

[复制链接]
发表于 2014-10-9 21:24:44 | 显示全部楼层 |阅读模式
有时候大家会碰到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, 即可获取密码。

QQ截图20141009172524.png

发表于 2014-10-10 02:46:49 | 显示全部楼层
直接vba编辑器里复制这个代码就行了  不用录制的
发表于 2022-6-8 11:15:55 | 显示全部楼层
谢谢楼主的分享
您需要登录后才可以回帖 登录 | 立即注册  

本版积分规则

扫码访问手机版

QQ|关于我们|网站地图|油气储运网 ( 鲁ICP备11007657号-3 )

GMT+8, 2024-11-21 22:41 , Processed in 0.027874 second(s), 17 queries , Gzip On, MemCached On.

Powered by Discuz! X3.5

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回列表