How can I remove the previous lock cells and keep the new ones.

M

Maperalia

Could you please help me?... I locked and protected the cells A1:H20 in the
sheet 1 two months ago. However, yesterday I wanted to unlock and unprotect
these cells and locked and protected the cells A21:H40 instead. However, for
some reason the cells A1:H20 are still lock and protect.
How can I remove the previous lock cells (A1:H20) and keep the new cells
(A21`:H40) only.

Thanks.
Maperalia
 
T

trip_to_tokyo

In EXCEL 2007 take the following actions to unlock cells A1 to H20:-

1. Home / Cells group / Format / Unprotect Sheet / enter the password to
Unprotect Sheet / OK / highlight cells A1 to H20 / Ctrl 1 / Custom Lists pop
up window should launch / Protection tab / remove the tick from the Locked
box / OK / save the file.

2. Close and reopen the file / make sure that you can access range A1 to
H20.

I have just tested the above and it works OK.

3. Apply the protection to the new range.

4. If my comments have helped please hit Yes.

Thanks.
 
M

Maperalia

Thanks very much. It works, I really appreciate your helping with this matter.
Thanks.
Maperalia
 

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

Top