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.