大家伙儿看过来啊!如果遇到设置了工作表保护的表格,想改东西却蹦出个密码框,别慌!要是忘记密码了,可以用宏命令把它揪出来~
具体咋操作?先点文件,再选选项,然后进自定义功能区。找到开发工具打个勾,点确定就OK啦!
接着在工具栏里找到开发工具,点开里面的宏,新建一个宏并保存。然后编辑这个宏,把下面这段代码直接复制进去:
Sub PasswordBreaker()
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
搞定后运行宏,密码就能现形啦!快去试试吧~
具体咋操作?先点文件,再选选项,然后进自定义功能区。找到开发工具打个勾,点确定就OK啦!
接着在工具栏里找到开发工具,点开里面的宏,新建一个宏并保存。然后编辑这个宏,把下面这段代码直接复制进去:
Sub PasswordBreaker()
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
搞定后运行宏,密码就能现形啦!快去试试吧~