You will be experienced, as has happened to us today, having modify an Excel spreadsheet that had been locked for editing with password using the option “Protection sheet“. Let's see how to solve the problem and remove the password of a protected Excel sheet editing…
The password protection of Excel worksheets, lets get locked cells where it is not possible to write.
Often Excel file that we created in the past, but can not remember your password,.
After many attempts no longer need to be discouraged: with a small procedure in VBA (you'll just have to paste the integrated Visual Basic Editor in Excel) we can now unlock cells, and choose a new password if you want to block them again to protect them from modification.
It is practically of a procedure that performs a crack excel password.
Here is the guide to unlock password-protected Excel files (crack password):
1) open your file and display the sheet stuck where you can not remember your password
2) press on the keyboard Alt F11 to open the VBA editor, or click “View Code” in the menu “Developer”.
If you don't have the option “Developer” in the upper menu, you need to activate it from Excel Options: File / Options / Customizing the Ribbon / On the right enabled the voice “Development”