Lock cell without protecting worksheet

paritoshkavra 

Protect / lock individual cells in Excel

1. First of all, you should prevent Excel from locking the entire document when sheet protection is activated.
2. So first select all cells of the table with Ctrl + A or click in the top left corner of the table.
3. Right click on any cell and select "Format Cells ...". In the Protection tab, remove the checkmark next to "Locked". Click OK.

1. Now, in Excel, use the mouse to select the cells or the range that you want to protect.
2. Right-click on it and select “Format cells ...” again. In the Protection tab, check the box next to Blocked.
3. Select the “Check” menu in Excel and click the “Protect sheet” button. Assign a password and confirm this twice.

Do not forget!

In "All users of this worksheet may:" submenu

The checkmarks for “Select locked cells” and “Select unlocked cells” should be ticked.

You can also do it with VBA code.

Sub CellProtect()
Dim Blatt As Worksheet, rng As Range
Set Blatt = Worksheets("Sheet1")
Set rng = Blatt.Range(Cells(1, 1), Cells(1, 1))
rng.Select
Blatt.Unprotect
Blatt.Cells.Locked = False
rng.Locked = True
Blatt.Protect
End Sub

Example file is inserted with VBA code

Additional Infos:

Lock or unlock specific areas of a protected worksheet

I would be happy to know if I could help.

NikolinoDE

Was the answer useful? Mark them as helpful!

This will help all forum participants.

Keliz123 

You wrote in the Wrong Message and Wrong Person. As far as I can see, I've been writing to another person. If you have any problem with any answer or with myself, you can send me a private message and I will answer you for sure.