顯示具有 VBA 標籤的文章。 顯示所有文章
顯示具有 VBA 標籤的文章。 顯示所有文章

2013年6月20日 星期四

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?