Protecting cells in a worksheet

**[email protected]** · 06-16-2010, 06:04 AM

Hi all,

Please I have some cells in a worksheet that have several formulars I would not want to be tampered with. So I need to lock the cells so that they can only be edited with password. The process I know which is going through Format>Cells>Protection.......... only gives a temporary solution.

I want the cells locked in such a way that each time they are tampered with, a password will be requested.

Please help.

**teylyn** · 06-16-2010, 06:19 AM

Hello,

select the cell(s) and then click Tools - Protection - Allow users to edit ranges

Specify a password. Make sure the cells are formatted as locked. Protect the sheet with a (different) password.
Now, when a user tries to edit one of the previously selected and protected cells, they will be asked for a password. This password will only unlock the cells, not the whole sheet.

cheers,

**[email protected]** · 06-16-2010, 06:37 AM

Please I tried the process but it did not work.

Probably because I do not know how to format cell as locked. Please I still need your help.

Thanks

**teylyn** · 06-16-2010, 07:39 AM

Select the cell, open the Format dialog, click the Protection tab and tick Locked.

By default, all cells are set to Locked. If you want users to edit cells after the sheet is protected, you need to untick this option.

cheers,

**[email protected]** · 06-16-2010, 09:27 AM

Thanks Teylyn. It worked perfectly. I appreciate.

**[email protected]** · 04-20-2013, 02:29 PM

Good day all.
Please I was using this solution in Office 2003 and it worked fine. But I'm having difficultly applying it in Office 2007. What are the steps for locking cells with password in Office 2007? Thanks.