Excel manage the VBA password simply comparing strings, so one method is simply to swap out the password entry in the file using a hex editor (Freeware Hex Editor and Disk Editor).

STEPS:

  1. Backup you file making a copy
  2. create a new simple Excel file
  3. In the VBA part (ALT + F11), set a simple password (for example 123).
    1. Open VBA part by pressing (ALT+F11)
    2. From “Tools” menu, select “VBAProject Properties…”
    3. Select “Protection” tab, and here input your desired password (like 123)
  4. Save the file and exit
  5. Open the file you just created with the hex editor.
  6. Copy the lines starting with the following keys:
    CMG=….
    DPB=…
    GC=…
  7. Open the file you want to crack with your hex editor and paste the above copied lines from the dummy file
  8. Save the excel file and exit
  9. Now open the excel file you need to see the VBA code in. The password for the VBA code will simply be 123.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...