How can I Unlock cell/worksheet?

L

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?
 
P

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.
 
L

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?
 
L

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?
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Locking by multiple users possible? 0
how can I lock/unlock a range of cells depending on state of a checkbox? 4
Unlink cells- how? 0
How do I clear a form? 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Unable to scroll in unlocked worksheet 1

Top