If an Excel spreadsheet is password protected, we are unable to edit the data in the sheet. If you do not remember the password or if you don't know the password to unprotect the excel sheet then just follow this process for unlocking the excel sheet.
Step 1:
Open the Excel sheet
Step 2:
Press Alt + F11 or click on view code on the developers tool
Then you would be seeing a sheet like this
Step 3:
In the above white space, just enter the code as shown below(Just Copy paste)
Step 4:
Now Click on F5 to run the code
and there youo get the unprotected excel sheet.
Now you get a message containing the password which can be ignored.
If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.
You can write us at dptutorials15@gmail.com
Comments