Don’t you just hate it when you forget a password? I’ve been in that situation many times simply because I do believe in hard-to-guess passwords while never writing them down (what’s the purpose of the password if you are going to write it down? :-)).

Here is a VBA (Visual Basic for Applications) macro for Excel that removes worksheet protection that I used almost 2 years ago when I needed to unprotect a file left by the person that held my position before me.

The idea of the macro is very simple: it loops generating passwords and provides you with one that will work. Note, that the one that it provides is almost never the one that was used to actually protect the worksheet but I am not going to explain why that is so. That is not the purpose of this post

I don’t know who wrote it but I know there are people that will one day need it so here you are: download the code here .

This macro should work with Excel 97, Excel 2000, Excel XP / Excel 2002, Excel 2003 and Excel 2007.

Tags: code breaker, excel 2000, excel 2002, excel 97, excel worksheet, passwords, vba visual basic, visual basic for applications