Removing password protection on a sheet

[Otto.tsl]

A co-worker of mine protected a sheet in her workbook but lost th
password. I help her with formula/script issues and I thought I coul
simply copy the data on this sheet and paste it to another sheet to ge
around it, but it won't let me select anything other than a few cell
(based on the cells settings I'm sure). I know that Microsoft doesn'
support removal of passwords when you don't know the password (make
sense from a secuity standpoint) but was hoping someone could help m
out here. She can remake it if need be but thought I'd ask

Thanks

 

[dominicb]

Good evening Otto.tsl

Fortunately for you, it's not that difficult to remove the workbook
worksheet protection from an Excel file.

This site should give you all the info you need.

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

HTH

Dominic

 

[Otto.tsl]

That did the trick, thanks very much! My Coworker is pleased that sh
didn't need to restart :