Simplest way is to ask the person for the password.
If they did the work for your company or were employed
by your company they almost certainly have a legal
obligation to provide that information.

If the password is lost, simply search Excel newsgroups
for password, there are lots of free password breakers.

I see you got the answer, but the first point is still valid
if it was done on purpose to keep the work from being
used if they weren't around.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Deb" wrote in message ups.com...
I have a work books that has been protected with a password but the
person who created the file is no longer employed with us, how can I
remove the protection without having to recreate the report?