Unprotect Sheet Password Lost

[Deana]

One of my users has inadvertently protected a worksheet (i.e. doesn't know
how he did it) while the AutoFilter was on. He has no idea what the password
may be. Is there any way to override this? Since the data was filtered, it
can't even be copied and pasted in to a new sheet.

Thanks for any help.

 

[Deana]

Thanks, this was just what we needed!

DJ

Check out

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