Wednesday, July 19, 2023

How to Break VBA Password in Excel 2021 and Previous Editions?

 

#1 Method – Break Excel VBA Module Password via Changing File Extension

  1. Change the VBA project file extension from *.xlsm to *.zip.
  2. Double-click on the ZIP file to open it with WinZip / WinRar programs.
  3. Click on the xl folder to continue.
  4. Extract the vbaProject.bin file and open it using Hex Editor.
  5. After that, search DPB in Hex Editor, replace it with DPx, and save it.
  6. Replace the old vbaProject.bin file with the new vbaProject.bin file under ZIP.
  7. Change the file extension from *zip to *.xlsm.
  8. Start Visual Basic in Microsoft Excel, select Tools, and VBAProject Properties.
  9. Choose the Protection tab, enter a new password and save the *.xlsm file.
  10. Finally, users can open the Excel VBA project file using the new password.