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

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?

2012年4月20日 星期五

Remove noise while adjusting the volume controller

Have you ever encountered the loud noise when you try to adjust the volume of any speaker?
I met that a lot in my life!
That won't trouble me after today. ;)

I googled this issue from the website.
And the answer is very very simple and easy.

All you need is one Q-Tips and 1ml or less of alcohol.

  1. Turn off the power, of course.
  2. Use the Q-Tips and get a little alcohol on it
  3. Drip the alcohol to the bottom part of the volume controller (the part connect to panel) 
  4. Adjust the volume controller from the lowest part to the loudest part one or two times.
  5. And guess what, the noise is gone!
  6. If its still there maybe there is really some problem with your volume controller. 
Hope this helps.