How can I remove workbook protection with no password?

I'm working in an Excel spreadsheet to collect data created by someone who no
longer works here. He password protected the whole workbook, but nobody
knows the password. I try to remove the protection, but obviously it asks me
for his password. Is there any way to remove the protection on the workbook
without the password??? Even if I could Save As the workbook under a new
name and go from there would work for me, but I can't seem to do it.

HELP!!!

Take a look here:

http://www.mcgimpsey.com/excel/fileandvbapwords.html


In article <[email protected]>,
"Tony" <[email protected]> wrote:

> I'm working in an Excel spreadsheet to collect data created by someone who no
> longer works here. He password protected the whole workbook, but nobody
> knows the password. I try to remove the protection, but obviously it asks me
> for his password. Is there any way to remove the protection on the workbook
> without the password??? Even if I could Save As the workbook under a new
> name and go from there would work for me, but I can't seem to do it.
>
> HELP!!!