Home » Questions » Computers [ Ask a new question ]

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

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

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

Asked by: Guest | Views: 25
Total answers/comments: 1
Guest [Entry]

"A couple different solutions could be used...

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