Excel Macro password hack needed

We had an employee leave the company and who we now find has password protected write access to several macros in an important spreadsheet.

When I try to edit the macro normally, I can select the Macro, but all options are then greyed out except the ability to run it. We need to edit it.

I tried to save the spreadsheet to Excel 95 version, but it won't let me with a "VBA Project password protected".

Is there any way to defeat the Excel Macro Password in the Visual Basic Editor?

Thanks,
Chuck

appelqAsked:
Who is Participating?
 
criConnect With a Mentor Commented:
If the work was done with Excel 97 there is a free tool. See VBAKEY from Pathologist under http://www.password-crackers.com/crack1.html
0
 
criCommented:
Go to any search engine, like www.google.com and give Excel password recovery as keywords. The choice is yours.
0
 
criCommented:
Ah...put VBA into the search too.

This seems to be capable, never tried it though

http://www.lostpassword.com/vba.htm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.