엑셀 VBA 암호풀기

출처 :

http://ddart.net/xe/board/5187

 

암호묻는 다이어로그 창의 리턴값을 1로 고정시켜서 암호를 맞게 입력한것으로 속이는 방법이다.

 

 

?

Excel 2007 Excel 2010 Excel 2013 Excel 2016

 

 

1. 락이걸린 엑셀파일을 연다.

2. 새 xlsm 파일을 생성한다.

3. Alt+F11 을 눌러 VBA를 실행한후 새로 만든 파일의 프로젝트를 선택하고 위의 메뉴의 Insert->Module 해서

   Module1 에 다음 코드를 복사해 넣는다 64bit 엑셀프로그램은 아래의 64bit 버전용 코드를 대신 삽입니다.

 

Excel 32bit 버전용 코드

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74

Option Explicit   Private Const PAGE_EXECUTE_READWRITE = &H40   Private Declare Sub MoveMemory Lib "kernel32" Alias "RtlMoveMemory" _         (Destination As Long, Source As Long, ByVal Length As Long)   Private Declare Function VirtualProtect Lib "kernel32" (lpAddress As Long, _         ByVal dwSize As Long, ByVal flNewProtect As Long, lpflOldProtect As Long) As Long   Private Declare Function GetModuleHandleA Lib "kernel32" (ByVal lpModuleName As String) As Long   Private Declare Function GetProcAddress Lib "kernel32" (ByVal hModule As Long, _         ByVal lpProcName As String) As Long   Private Declare Function DialogBoxParam Lib "user32" Alias "DialogBoxParamA" (ByVal hInstance As Long, _         ByVal pTemplateName As Long, ByVal hWndParent As Long, _         ByVal lpDialogFunc As Long, ByVal dwInitParam As Long) As Integer   Dim HookBytes(0 To 5) As Byte Dim OriginBytes(0 To 5) As Byte Dim pFunc As Long Dim Flag As Boolean   Private Function GetPtr(ByVal Value As Long) As Long     GetPtr = Value End Function   Public Sub RecoverBytes()     If Flag Then MoveMemory ByVal pFunc, ByVal VarPtr(OriginBytes(0)), 6 End Sub   Public Function Hook() As Boolean     Dim TmpBytes(0 To 5) As Byte     Dim p As Long     Dim OriginProtect As Long       Hook = False       pFunc = GetProcAddress(GetModuleHandleA("user32.dll"), "DialogBoxParamA")         If VirtualProtect(ByVal pFunc, 6, PAGE_EXECUTE_READWRITE, OriginProtect) <> 0 Then           MoveMemory ByVal VarPtr(TmpBytes(0)), ByVal pFunc, 6         If TmpBytes(0) <> &H68 Then               MoveMemory ByVal VarPtr(OriginBytes(0)), ByVal pFunc, 6               p = GetPtr(AddressOf MyDialogBoxParam)               HookBytes(0) = &H68             MoveMemory ByVal VarPtr(HookBytes(1)), ByVal VarPtr(p), 4             HookBytes(5) = &HC3               MoveMemory ByVal pFunc, ByVal VarPtr(HookBytes(0)), 6             Flag = True             Hook = True         End If     End If End Function   Private Function MyDialogBoxParam(ByVal hInstance As Long, _         ByVal pTemplateName As Long, ByVal hWndParent As Long, _         ByVal lpDialogFunc As Long, ByVal dwInitParam As Long) As Integer     If pTemplateName = 4070 Then         MyDialogBoxParam = 1     Else         RecoverBytes         MyDialogBoxParam = DialogBoxParam(hInstance, pTemplateName, _                            hWndParent, lpDialogFunc, dwInitParam)         Hook     End If End Function

 

64bit 버전 엑셀용 코드

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75

Option Explicit   Private Const PAGE_EXECUTE_READWRITE = &H40   Private Declare PtrSafe Sub MoveMemory Lib "kernel32" Alias "RtlMoveMemory" _ (Destination As LongPtr, Source As LongPtr, ByVal Length As LongPtr)   Private Declare PtrSafe Function VirtualProtect Lib "kernel32" (lpAddress As LongPtr, _ ByVal dwSize As LongPtr, ByVal flNewProtect As LongPtr, lpflOldProtect As LongPtr) As LongPtr   Private Declare PtrSafe Function GetModuleHandleA Lib "kernel32" (ByVal lpModuleName As String) As LongPtr   Private Declare PtrSafe Function GetProcAddress Lib "kernel32" (ByVal hModule As LongPtr, _ ByVal lpProcName As String) As LongPtr   Private Declare PtrSafe Function DialogBoxParam Lib "user32" Alias "DialogBoxParamA" (ByVal hInstance As LongPtr, _ ByVal pTemplateName As LongPtr, ByVal hWndParent As LongPtr, _ ByVal lpDialogFunc As LongPtr, ByVal dwInitParam As LongPtr) As Integer   Dim HookBytes(0 To 5) As Byte Dim OriginBytes(0 To 5) As Byte Dim pFunc As LongPtr Dim Flag As Boolean   Private Function GetPtr(ByVal Value As LongPtr) As LongPtr     GetPtr = Value End Function   Public Sub RecoverBytes()     If Flag Then MoveMemory ByVal pFunc, ByVal VarPtr(OriginBytes(0)), 6 End Sub   Public Function Hook() As Boolean     Dim TmpBytes(0 To 5) As Byte     Dim p As LongPtr     Dim OriginProtect As LongPtr       Hook = False       pFunc = GetProcAddress(GetModuleHandleA("user32.dll"), "DialogBoxParamA")         If VirtualProtect(ByVal pFunc, 6, PAGE_EXECUTE_READWRITE, OriginProtect) <> 0 Then           MoveMemory ByVal VarPtr(TmpBytes(0)), ByVal pFunc, 6         If TmpBytes(0) <> &H68 Then               MoveMemory ByVal VarPtr(OriginBytes(0)), ByVal pFunc, 6               p = GetPtr(AddressOf MyDialogBoxParam)               HookBytes(0) = &H68             MoveMemory ByVal VarPtr(HookBytes(1)), ByVal VarPtr(p), 4             HookBytes(5) = &HC3               MoveMemory ByVal pFunc, ByVal VarPtr(HookBytes(0)), 6             Flag = True             Hook = True         End If     End If End Function   Private Function MyDialogBoxParam(ByVal hInstance As LongPtr, _ ByVal pTemplateName As LongPtr, ByVal hWndParent As LongPtr, _ ByVal lpDialogFunc As LongPtr, ByVal dwInitParam As LongPtr) As Integer       If pTemplateName = 4070 Then         MyDialogBoxParam = 1     Else         RecoverBytes         MyDialogBoxParam = DialogBoxParam(hInstance, pTemplateName, _                    hWndParent, lpDialogFunc, dwInitParam)         Hook     End If End Function

 

4. 같은방법으로 Insert->Module로 모듈생성후 Module2 에 다음코드를 복사한다

 

?

1 2 3 4 5

Sub unprotected()     If Hook Then         MsgBox "VBA Project is unprotected!", vbInformation, "*****"     End If End Sub

 

5. F5를 눌러 unprotected를 선택해 실행한다

 

6. 이제 암호걸렸던 VBA Project를 열어보면 더이상 암호를 묻지 않게된다. 도구의 프로젝트 속성에 가서 protected 모드를 해제하면 완벽히 제거된다.