How can I Unlock cell/worksheet?

[Lyn]

I received a spreadsheet that has been used as a form and only the cells
where information is to be populated are accessible. I thought I could do a
Save As or even copy all the contents and paste them into a new spreadsheet
so I can alter the cells that are not accessible, but I am unable to do this.
I cannot contact the originator for an editable version. How can I work
around this?

 

[Jim Thomlinson]

XL passwords are not very secure... Check out this link...

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

Please use these powers for good instead of evil...

 

[Patricia]

You can try unprotecting it. That will do it if they did not password protect it.
In Excel 2007, go to Home>Cells>Format and select Unprotect.

 

[Lyn]

It does not ask for a password when I open it, but when I try to do as you
have suggested, "Cell" is grayed out so I don't have the option to change it.
Any other suggestion?

 

[Lyn]

While that's interesting, I didn't find anything that I could understand to
help me with this issue. Can you dumb it down?

 

[Don Guillett]

If you can prove to me that you are authorized to do this, send to me and I
will unprotect for you.