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