Well it sounds as if somebody has, Melody!

If the password is needed to open the file, then someone has either
put a workbook password on it, or you are trying to open it from a
server or Sharepoint site that you don't have access to.

There are a number of password crack programs on the Net or
alternatively somebody in the newsgroup may come up with a macro
(which I doubt, 'cos I've tried!)

I use a password cracker that I had to pay for (about $10) - and it
works. Do a Google for excel Workbook passwords and you should find
one.

Hope that helps

Phil