top of page
  • Writer's pictureDp

How To Unprotect An Excel Sheet Without Password

Updated: May 16, 2019

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

0 comments

Recent Posts

See All

Comments


bottom of page