That’s it, your Excel workbook or spreadsheet should be now unprotected. You should get a pop-up window when your spreadsheet has been unprotected: If your current settings are high, set them to medium.Īfter you click on Enable Macros, you will get a pop-up saying the macro is loaded:Īfter you get the pop-up, on Excel go to Tools, and click on Unprotect workbook and Unprotect sheet. If you get a different message, probably you need to lower your security settings on your Excel. After the password-protected sheet is open, click to open the password.xla add-in, you should get a warning like this: Open your password-protected sheet or workbook. Here we’ll show you how to remove MS Excel XP password. If this pass and the new password corresponds to the one inserted in the verification box the code has to carry on and change the old password value with the new one. First of all it recalls the username from another sheet and compares it with the entried password on the password change form. password.xla is designed to remove MS Excel 97/2000/XP/2003 passwords while password_2007_2010.xlam is for removing Excel 2007/2010 passwords. The code I developed so far is quite simple. Unzip the download file, there are two files: password.xla and password_2007_2010.xlam. Then you need to get our Excel Password Recovery program to crack the file open password.Įxcel Password Remover is a program to remove the password to be able to modify an existing password protected workbook or spreadsheet, with that in mind let’s proceed on how to use it.ĭownload Excel password remover from this link. If you are unable to open the file because it asks you for a password, this program won’t help you.

Note: Excel Password Remover can’t be used to remove password set to open a spreadsheet. what do you do? easy, use Excel Password Remover. Can’t open password-protected Excel files? How many times has happened that you set a password on an Excel spreadsheet or workbook and then you forget about it? or worst, the person that set up the password on the spreadsheet no longer works with you, and you have a spreadsheet that can’t modify. Replace the old vbaProject.bin in the ZIP file with the new hex edited versionĬhange the file's extension back to. Perform steps #1-3 above ( from the For older. Go into the xl directory and extract vbaProject.bin: Open the file in any archiver such as WinRAR or 7-Zip and you'll see the following directory structure: OK your way out and now the VBA code is accessible! Re-check the Lock project for viewing checkbox and add your own memorable password. Right-click the VBA project name, select Properties, go to the Protection tab and delete the existing passwords as well as uncheck the Lock project for viewing checkbox: Open the VBA editor ( Alt+ F11) and press OK whenever the following warning pops up:

Click on Recover From File button and then choose VBA Password in the list. Open the file in Excel and press Yes if the following warning pops up: Start the Password Recovery Bundle program. Search for the text ' DPB=' (no quotes, you should find it just above ''Ĭhange it to ' DPx=', save and close the file

Excel macro password forgot