Ever encounter an old Excel VBA macro project locked by password. Chances are, you have forgotten what is the password. This method from stackoverflow is the best that I can use to unlock and remove the password easily!

Things you need will be a Hex editor. I use Textpad++ with Hex editor plug in.
- You may want to backup your file before changing.
- Open xls file with a hex editor in Textpad++.
- Ctrl Find and search for DPB
- Replace DPB to DPx
- Save file.
- Open file in Excel.
- Click “Yes” if you get any message box. It usually will show a corrupted message information.
- In the Visual Basic Editor window, click Tools -> VBA Project Properties.
- The VBA Project – Project Properties window opens. Select the Protection tab, tick the Lock project for viewing, enter and confirm a password, then click OK.
- Enter new password.
- Save and Close.
- Open the file with Excel.
- You will notice that there is no error message box.
- Enter your new password when you open to view VBA project. Viola!
Below steps is optional to remove the password.
- In the Visual Basic Editor window, click Tools -> VBA Project Properties.
- The VBA Project – Project Properties window opens. Select the Protection tab, untick the Lock project for viewing, then click OK.
- Save and Close.
- Open the file with Excel.
- Click to view VBA project and you are able to view without any password.
Stackoverflow