VBA code to crack Excel worksheet password

Use Alt+F11 to enter the macro editor. Once in VBA double click the sheet you need to unlock from the menu listing on the left. This will open the general declarations page for the sheet. Sub PasswordBreaker() 'Breaks worksheet password protection.

A password protected excel file can sometimes be recovered using specific tools such as HashCat or John the Ripper.

Unfortunately, if this has happened to you, there is no simple and easy way to recover a lost password. Excel doesn't store the passwords you use to lock your spreadsheet nor can Microsoft can “look them up” for you. This is also true for the other software in the Office suite that lets you protect files.