Redo the previous step but this time you can remove (delete) the password.
Open again the Visual Basic window and enter the password you just put in. Save the workbook and then close and reopen. Open the Visual Basic window (usually ALT+F11 if I remember correctly) and open the VBAProject properties ( Tools menu).Ĭlick on the Protection tab and change (do not remove at this stage) the password to something short and easy to remember (we'll be removing in next step). Open the file in excel - you may receive a couple of error notifications, just click through them. Now basically just click on the B in DPB and replace it with an 'x', like this: xla file, open the file in your hex-editor and find for text string 'DPB': Use a hex editor to find and replace 'DPB' with 'DPx' Make sure you have a backup of the file in case something goes wrong. Plus, I quite enjoyed removing passwords with this approach since it reminded me of my youth and hex-editing files (anyone remember hex-editing SimCity 2000 saves to give you lots of money?). In the instances that I did (remove the password) it was not for nefarious purposes, but because someone had either forgotten the password or had a file they were now responsible for and the previous user had (who set the password) had left the company. I usually don't deal with VBA (thank goodness) - but I have been asked on several occasions to remove a VBA password from an excel workbook.
