I have an Excel workbook.
Two years before I set password protection option for one of the sheets. Now I have forgotten the password. Is there any way to recover the password of that Excel sheet?
migrated from stackoverflow.com Sep 23 '09 at 21:06
This question came from our site for professional and enthusiast programmers.
You cannot recover THE password, but you can unprotect the sheet(The hash used to protect the sheet is quite prone to collisions in the old versions of excel, so generating a collision is quite fast here).
There are scripts availale the will brute force open your sheet within a very short amount of time.
Take a look here for example: http://www.theofficeexperts.com/VBASamples/Excel02.htm
Here's the code: