Removing the password from a VBA project

by

Another way to remove VBA project password is;

  • Open xls file with a hex editor.
    (ie. Hex Edit http://www.hexedit.com/)
  • Search for DPB
  • Replace DPB to DPx
  • Save file.
  • Open file in Excel.
  • Click “Yes” if you get any message box.
  • Set new password from VBA Project Properties.
  • Close and open again file, then type your new password to unprotect.

UPDATE: For Excel 2010 (Works for MS Office Pro Plus 2010 [14.0.6023.1000 64bit]),

  • Open the XLSX file with 7zip

If workbook is protected:

  • Browse the folder xl
  • If the workbook is protected, right click workbook.xml and select Edit
  • Find the portion <workbookProtection workbookPassword="XXXX" lockStructure="1"/> (XXXX is your encrypted password)
  • Remove XXXX part. (ie. <workbookProtection workbookPassword="" lockStructure="1"/>)
  • Save the file.
  • When 7zip asks you to update the archive, say Yes.
  • Close 7zip and re-open your XLSX.
  • Click Protect Workbook on Review tab.
  • Optional: Save your file.

If worksheets are protected:

  • Browse to xl/worksheets/ folder.
  • Right click the Sheet1.xml, sheet2.xml, etc and select Edit.
  • Find the portion <sheetProtection password="XXXX" sheet="1" objects="1" scenarios="1" />
  • Remove the encrypted password (ie. <sheetProtection password="" sheet="1" objects="1" scenarios="1" />)
  • Save the file.
  • When 7zip asks you to update the archive, say Yes.
  • Close 7zip and re-open your XLSX.
  • Click Unprotect Sheet on Review tab.
  • Optional: Save your file.

More Related Contents:

  1. Sheet protection: UserInterFaceOnly gone
  2. Loop through files in a folder using VBA?
  3. How to error handle 1004 Error with WorksheetFunction.VLookup?
  4. How can Excel VBA open file using default application
  5. How to compare two entire rows in a sheet
  6. Run same excel macro on multiple excel files
  7. how to detect whether VBA excel found something?
  8. VBA : save a file with UTF-8 without BOM
  9. Saving a Excel File into .txt format without quotes
  10. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  11. Determine if cell contains data validation
  12. VBA – Range to jpg picture
  13. Fastest way to delete rows which cannot be grabbed with SpecialCells
  14. Combine multiple Excel workbooks into a single workbook
  15. Excel Macro, inserting internationally valid formula during run-time
  16. How to break long string to multiple lines
  17. vba paste not working
  18. mac excel vba loop : from list & then export as pdf
  19. Can Advanced Filter criteria be in the VBA rather than a range?
  20. In Excel VBA, what is the way to check if the web page is fully loaded?
  21. Excel Useform: How to hide application but have icon in the taskbar
  22. Reading Web Pages using Excel VBA
  23. Excel VBA: auto click and open file from website
  24. Calling regasm without administrative rights for COM interop in Excel VBA
  25. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  26. How do I activate a specific workbook and a specific sheet?
  27. Start VBA macro when editing a cell
  28. VBA Run-time error 438 appears when “paste” runs
  29. If Not function proceeds when value *is* the one specified
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment