Tuesday, May 28, 2013

How to unlock and remove passwords on XLS/XLA 2003 files

  1. Use a Hex editor to open the XLS file 
  2. Search for "DPB="
  3. Edit "DPB=" to "DPx="
  4. Save the XLS file from the Hex editor
  5. Open the XLS file, Excel should throw up an error saying " Do you want to continue loading the project?" Click
  6. Press ALt+f11 and go the the properties of the VBA code and tyep a new password. 
  7. Save the XLS file
  8. Close and re-open the XLS file

 This only works for XLS 2003 format files. This process will not work in Office 2007/2010 documents

If you find this article useful please leave me a comment or click on an ad to show your support.