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
- Download the Script file from this link (ScriptFile)
- Open the Password Protected Excel File
- Press ALT+F11 on your keyboard; the Visual Basic Editor opens
- From the File Menu; click Import and select the BASE Script file () that you downloaded earlier
- From the File Menu; click Close and Return to Microsoft Excel
- From the View Tab in Excel; Click View Macros (Illustration provided below)
- Select Macro1 and Click Run (Illustration provided below)
- The password removal utility that opens will guide you through the rest
Open the Password Protected Excel File (Really????? This is the problem!)