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!!!

How can I remove workbook protection with no password?
 

Take a look he

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


In article ,
"Tony" 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!!!