One time only cell can edit

[Abhijeet]

Hi

I want to know how one time cell can edit in particular range after 1st time cell can not allow to edit or delete or any kind of changes please tell me how to do this

 

[jindon]

Don't know if you want this though...

1) Select all the cells in the worksheet
2) Right click, and then click Format Cells
3) Uncheck the Locked check box on the Protection tab then OK

Paste the code onto the code module of the worksheet.
(Right click on the sheet tab - [View Code])

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim r As Range
    Me.Unprotect
    For Each r In Target
        r.Locked = True
    Next
    Me.Protect
    Me.EnableSelection = 1
End Sub

 

[Abhijeet]

This is ok but i want to copy paste that lock cell this macro not allow to do this so please tell me