We get this sort of problem all the time at work.

Try ElcomSoft Co.Ltd and download AOPR (Advanced office password recovery)

It will recover anything from office inclusing VBA, Excel, macro etc etc.

I do it all the time, there are other tolls out there too such as Password Tools.

Just google Password tools or just go to http://www.elcomsoft.com/aopr.html which is all you need for you what u describe.