Is there anyway to make particular-selected cells in MS Excel as read-only?

Question

By LOCKING the cells, and switching protection on will make whole file read-only .. But I want to make only few/selected cells as read-only .. that means, those cells cannot be edited anymore ..

Is there any facility as such pre-defined in MS-office .. Please let me know if you aware of this feature ..

Answer 1

A couple different solutions could be used...

1. With the sheet not protected, use Format - Cells - Protection tab. Uncheck "Locked" for those cells to be changeable. Now protect the sheet with Tools - Protection - Protect sheet.

2. If the first solution doesn't work, you could always use a macro to automatically kick people out of the cells you don't want them in. You could use a macro similar to the one below. Based on your selection, if it falls between the Range(A1:A4) it'll automatically kick you out of those cells and dump you into cell B1. I suppose you could use inidividual cells instead of a range.

---

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  If Not Intersect(Selection, Range("A1:A4")) Is Nothing Then
    Range("B1").Select
  End If
End Sub

Answer 2

You don't have to lock the whole sheet. You can just lock a few cells then protect the sheet, then the rest of the cells can be edited still.