TEXT 61
Excel Remove Password By mike on 28th March 2021 03:49:15 PM
  1. Source
  2. https://davidmurdoch.com/2014/11/19/remove-password-from-vba-project/
  3.  
  4. Port Hex Editor (tested)
  5. https://portableapps.com/apps/development/frhed_portable
  6.  
  7.  
  8.  
  9. Remove Password from VBA Project
  10.  
  11. For XLSM files:
  12.  
  13.     Open the XLSM file with 7-Zip (right click -> 7-Zip -> Open archive).
  14.     Copy the xl/vbaProject.bas file out of the file (you can drag and drop from 7-Zip), don't close 7-Zip
  15.     Open the vbaProject.bas file with HexEdit
  16.     Search for "DPB=" and replace it with "DPx="
  17.     Save the file
  18.     Copy this file back into 7-Zip (again, drag and drop works)
  19.     Open the XLSX file in Excel, if prompted to "Continue Loading Project", click Yes. If prompted with errors, click OK.
  20.     Press F11 to open the VBA editor.
  21.     Right click on the VBA project, select properties. Open the Protection tab then uncheck "Lock project for viewing". Press OK
  22.     Save and Close the XLSM file
  23.     Re-open the XLSM file and proceed to edit/view the VBA project macros.
  24.  
  25. For XLS files:
  26.  
  27.     Open the XLS file with HexEdit
  28.     Search for "DPB=" and replace it with "DPx="
  29.     Save the file
  30.     Open the file in Excel, if prompted to "Continue Loading Project", click Yes. If prompted with errors, keep clicking OK.
  31.     Press F11 to open the VBA editor.
  32.     Right click on the VBA project, select properties. Open the Protection tab then uncheck "Lock project for viewing". Press OK
  33.     Save and Close the XLS file
  34.     Re-open the XLSM file and proceed to edit/view the VBA project macros.

Hasta la pasta! is for source code and general debugging text.

Login or Register to edit, delete and keep track of your pastes and more.

Raw Paste

Login or Register to edit or fork this paste. It's free.