Ticker

6/recent/ticker-posts

An Easy Way to Unprotect Workbook Excel without a Password

Excel Protect Workbook is a fantastic tool for preventing data from making any changes to your workbook. But if you forget the password of your protected workbook, you will have a very big headache trying to enter the password. So, today we'll show you a quick solution to remove your password from your Excel Protect workbook.


Excel Password Protected Workbook Removal

1. Change your excel file's extension from *.xlsx or *.xlsm to *.zip. After that, you will get a warning asking you to click Yes.
2.  You click to open the *.zip file after your file Excel has been converted.
3. Select the folder "xl" and then click open "workbook.xml"in notepad.


4. Press Ctrl+F to search for "workbookProtection".
5. Select this entire line between "<" and ">" and delelte it, then click save.

6. After you save the file, you will get a warning asking you to confirm the modification. Click "Yes."
7. Let's rename the file's extension back from *.zip to your excel extension.
8. Open your Excel file. Then you will have access to the excel without the password.




Conclusion

In this post, we have made a step-by-step tutorial on An Easy Way to Unprotect Workbook Excel without a Password.I hope you liked it and please do share it with your friends and follow our social media for more.

If you face any problems with the code or have any questions, please feel free to ask in the comments section or contact us.

Post a Comment

0 Comments