How to remove Microsoft Excel VBA password?

Origin from Google Group

I wish no one use this skill to do anything bad.

The original idea was to modify some program logic from my previous Excel VBA master.

I'm just a very very normal IT guy.  

First of all you need a Hex editor.

Open your Excel file in the Hex editor.

Find the DPB in the file (In ASCII mode of course)

Then modify the B to anything else, in the discussion of Google Group Shameer suggested to use x.

So that would change the DPB to DPx.

Now save your file.

Open up your modified Excel, lots of error messages popup.

Just keep press OK.

Now ALT+F11 to open up your VBA Editor, you'll see the password now is empty!

Now you can change it to something else save it back, and everything will be back.

 

Cool, isn't it?