if your workbook is protected with a
password and you want to remove the
password open the file protected with
password Excel prompts for the password
enter the current password click on OK
Excel opens the workbook click on file
click on info click on protect workbook
in the drop-down list click on encrypt
with password Excel displays encrypt
document window and password is
defaulted with current password of
workbook to remove the password
protection blank out the password click
OK
click on sale
which will remove the password
protection for the workbook close the
file open the same file again
you can see Excel doesn't prompt for a
password