大家伙兒看過來啊!如果遇到設(shè)置了工作表保護的表格,想改東西卻蹦出個密碼框,別慌!要是忘記密碼了,可以用宏命令把它揪出來~
具體咋操作?先點文件,再選選項,然后進自定義功能區(qū)。找到開發(fā)工具打個勾,點確定就OK啦!
接著在工具欄里找到開發(fā)工具,點開里面的宏,新建一個宏并保存。然后編輯這個宏,把下面這段代碼直接復制進去:
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
搞定后運行宏,密碼就能現(xiàn)形啦!快去試試吧~
具體咋操作?先點文件,再選選項,然后進自定義功能區(qū)。找到開發(fā)工具打個勾,點確定就OK啦!
接著在工具欄里找到開發(fā)工具,點開里面的宏,新建一個宏并保存。然后編輯這個宏,把下面這段代碼直接復制進去:
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
搞定后運行宏,密碼就能現(xiàn)形啦!快去試試吧~