Remove Workbook or Sheet password¶

Rename file.xlsx to file.zip unzip open in xl\ the sheet or workbook xml CTRL+F, protect Remove html tag <sheetProtection till and including />

Remove VBA Project password¶

Rename file.xlsm to file.zip unzip extract vbaProject.bin open vbaProject.bin (vscode, hex) Find DPB Replace the code in the double quotes with 686AC40BE10BE1F41F0CE1B43AA79DC6A1F4BC5E9593C212EA5E3ABCF1CB9A3B4F78F0BA If the length of the password hash differs from the lenght of the Welkom01 hash, revert to the trumpexcel.com article. replace vbaProject.bin in the zip file rename back to xlsm open the vba code with password Welkom01 and remove the password

https://trumpexcel.com/excel-vba/remove-password/ https://agio.com/how-to-unlock-protected-excel-sheets-without-a-password/#gref