How to unprotect Excel Sheet and restore password

Excel has useful features for developing forms and hiding information so that it’s easy to create mini apps which take user entered information, combine with data stored in the spreadsheet and provide an answer. Some of the spreadsheets are very sophisticated and Excel offers a “protect” feature that locks down a sheet (or workbooks) and prevents unwanted meddling or fiddling with the data. The protect feature even lets the owner set a password so that the more determined meddler can be thwarted and confidential data kept confidential.

1- Go to file menu click option (This step if developer menu not available). (Delete remove password from excel )

2-Go to customize ribbon, on the right side tick mark developer.(remove password from excel )

3- Go to main menu select developer then click visual basic. ( Delete remove password from excel )

4-Double click in your sheet the dialog box will open at right side then paste the code (available end of this post) and close the visual basic only not excel sheet.

5-Go to main menu select developer then click Macros

6-Select Macros then click Run

7-Click NO .

8-Now click ok and enjoy please share this post and put your comment .

For more details see this video

Copy this code to excel sheet


https://drive.google.com/file/d/0B6oAUSz7kAzYOW16Vk5MTzZna3M/view?usp=sharing