There are several fairly inexpensive (under $50?) programs you can find by searching "crack macro password excel 2010", although I haven't used any and cannot make any personal recommendations.
Hi,
You will see answers here stating there is software out there that can hack and crack the code. Basically you (or better your company) is at a stand still. Software that can crack passwords is software that handles against agreements. Your company had a password on the file for a reason or the developer placed a password to protect the intellectual property of the code. If you are an employee at that specific company you have to explain that there are two options available. 1. use software that cracks the password, which i think will be against company policy or 2. accept the fact that the file is password protected and conclude that the file has to be remade.
Tough call to make. I'd say let the company decide and don't go on a personal hunt for the solution here...
Maurice