In this article, I will try to explain how to unlock the locked excel file.
First of all, we open a locked / protected excel file.
We enter the developer environment with the ALT + F11 key.
In Developer Mode, we point to the project, right click and press the insert — module button.
A blank page will open up against us, we paste the macro code I wrote in the link on this page and close the page.
( Link : https://github.com/omurugur/Excel_Password_Broke )
Excel remains open, we just close the macro, we can see macros with ALT + F8 on excel. After doing this, we select the remove password macro and continue by saying ok.
and then we come across the protection password and we can work on the excel, broken. When you save the Excel file differently, you can save it without a password.
Don’t forget to activate macros and developer modes on excel
