使用这个答案作为参考:Is there a way to crack the password on an Excel VBA Project?
而不是做所有的杂事。你可以试试这个。它适用于任何文件(*.xls、*.xlsm、*.xlam .)。测试和工作在Excel 2007,Excel 2010和Excel 2013年- 32位版本。
- 打开包含锁定的VBA项目的文件。
- 创建一个新的xlsm文件并将此代码存储在Module1中。
选项显式私有PAGE_EXECUTE_READWRITE =&H 40私有声明子MoveMemory Lib "kernel32“Alias "RtlMoveMemory”_(目的为长,源为长,ByVal长度为长)私有函数VirtualProtect Lib "kernel32“(lpAddress As Long,_ ByVal dwSize As Long,ByVal flNewProtect As Long,lpflOldProtect As Long)作为长私有声明函数GetModuleHandleA Lib "kernel32”(ByVal lpModuleName作为字符串)长的私有声明函数GetModuleHandleA Lib "kernel32“()_ ByVal lpProcName As String)长私有声明函数DialogBoxParam Lib "user32“Alias "DialogBoxParamA”(ByVal hInstance As Long,_ ByVal pTemplateName As Long,ByVal hWndParent As Long,_ ByVal lpDialogFunc If,ByVal dwInitParam As Long)为Integer Dim HookBytes(0至5)和Byte Dim OriginBytes(0至5)和Byte Dim HookBytes(0至5)和Byte Dim OriginBytes,Long DialogBoxParamA( Value As Long)为Long =值结束函数Public Sub (如果国旗#en23#,ByVal VarPtr(OriginBytes(0)),6 End Function Hook()表示布尔Dim TmpBytes(0至5) As Byte Dim p If Dim OriginProtect As Long pFunc = False pFunc=False“DialogBoxParamA”如果VirtualProtect(ByVal pFunc,PAGE_EXECUTE_READWRITE,OriginProtect) <> 0,MoveMemory ByVal VarPtr(0),MoveMemory,6如果TmpBytes(0) <> &H68然后MoveMemory ByVal VarPtr(OriginBytes(0)),ByVal pFunc,6p= GetPtr(AddressOf MyDialogBoxParam) HookBytes(0) =&H 68 MoveMemory ByVal VarPtr(HookBytes(1)),ByVal VarPtr(p),4 ByVal (5)= &HC3 en21#,en23#((0)),6 Flag = True Hook = True End If End If MyDialogBoxParam(ByVal hInstance As Long,_ ByVal pTemplateName As Long,ByVal hWndParent As Long,_ ByVal lpDialogFunc As Long,ByVal dwInitParam As Long)为整数,如果pTemplateName = 4070,MyDialogBoxParam =1 RecoverBytes MyDialogBoxParam = DialogBoxParam(hInstance,pTemplateName,_hInstance,,( dwInitParam)钩端如果结束函数
- 将此代码粘贴到Module2中并运行它
如果MsgBox“unprotected是不受保护的!”,vbInformation,“*”如果结束,则结束
- 回到您的VBA项目,并享受。
P/S:此代码被记入越南开发人员Siwtom (尼克名)的名下。您可以将此代码转换为Excel加载项,以便经常使用。