There are several instances when we would have protected entire Excel Workbooks or specific Worksheets and then totally forgotten about it.  An online search will fetch a thousand options for password removal.

The one on this blog is simple, straight-forward and no software requires to be download. All we need is a simple BASE Script

This has tried and tested on Excel 2007 and 2010 versions

1. Download the Script file from this link (ScriptFile)
2. Open the Password Protected Excel File
3. Press ALT+F11 on your keyboard; the Visual Basic Editor opens
4. From the File Menu; click Import and select the BASE Script file () that you downloaded earlier
5. From the File Menu; click Close and Return to Microsoft Excel
6. From the View Tab in Excel;  Click View Macros (Illustration provided below)
7. Select Macro1 and Click Run (Illustration provided below)
8. The password removal utility that opens will guide you through the rest