Excel has updated their sheet protection security in Excel 2013 and newer so this macro won't work anymore, see here. From the link it sounds like if you save the file as an xls file (Excel 1997-2003) it is forced to drop the newer security as it wasn't compatible with the file type. Tips and notes: If your Excel file contains more than one protected sheet, run the macro for each sheet individually to unprotect it. To unprotect Excel sheet without password in the modern versions of Excel 2013 and Excel 2016, you can save the document as Excel 97-2003 workbook (.xls) first, run the macro to unprotect it, and then save the workbook back as an.xlsx file.
Active11 days ago
Anybody knows if there are other ways to crack a password of a protected sheet in excel? I have been using these codes ever since but now, it doesn't seem to work anymore. The file just says 'Not Responding' every time I run the code. I'm using MS Office 2013.
PGSystemTester2,91711 gold badge1010 silver badges2929 bronze badges
MeedeeMeedee
4 Answers
Excel has updated their sheet protection security in Excel 2013 and newer so this macro won't work anymore, see here.
From the link it sounds like if you save the file as an xls file (Excel 1997-2003) it is forced to drop the newer security as it wasn't compatible with the file type. You could then run your macro.
Saving as an older file version may make certain parts of the workbook not work.
gtwebbgtwebb2,50322 gold badges99 silver badges2121 bronze badges
Hack Protected Excel Sheet In Bangla
I'm not sure how this works but I was able to Unprotect the sheet. I did a 'save as' and changed the Type to: 'Excel 97-2003'. When I opened the file & unprotect the sheet, it did not ask for a password anymore. :) And my workbook still works fine.
MeedeeMeedee
Excel Protected Sheet
Thanks Kawi, that works perfectly.
Here is the full code with Kawi's modification:
YBNormalYBNormal
Break Into Protected Excel Sheet
Since a recent update, Excel has an issue with a high try rate to command Unprotect. A few slow-down makes the code run again: Put something like this right before the Unprotect line, i.e. into the most inner loop:
With this (speed-) modification, the initial mentioned approach works also with Excel 2013 and Excel 2016.
Kawi42Kawi42