VB password problem

I have a spreadsheet in work that a guy made that has some macros. He left the company about 3 years ago but I now need to amend the code. When I richt click on the button and select assign macro and then edit, I get an inputbox 'VBAproject password' and asked to input the password. problem is I don't know it, is there any way to hack this?

thanks

yes there is a way to unprotect your SpreadSheet or WorkBook.

Not sure it will work with the VBA Project Password, but give it a try is cost less

add this add-ins to your excel
Password remover

FYI: this will not work on the VBProjects password..
I am affraid you are out of luck. I needed to do the same thing and could not find ANYTHING to remove the password from the project part...
http://www.vbforums.com/

Static is rignt. I've searched many time for a way to unprotect a VBA Project and never found an answer.

Have you tried this?

http://lastbit.com/vba/

BTW I'm afraid it's not free :cry: