Private Sub Worksheet_Change(ByVal Target As Range)
If WorksheetFunction.IsText(Target.Value) Then
ActiveSheet.Unprotect "MyPassword" 'Delete if no password needed
Target.Locked = True
ActiveSheet.Protect "MyPassword"
End If
End Sub
tryed that code but it still locks all cells
tryed 6...
Im still needing a macro because using the protect sheet feature doesnt do all i need
I need cells to automatically lock once data is imput but still allow people to imput text on the cells that have no text in yet
I should have also put that I need it so once text is inputted the cell locks itself {after saving or some other action} So previous boxes cant be overwritten
I have a excel sheet that multiple people use that is used for imputting batch numbers and the like the issue is people keep imputting data into previous cells and messing up data
I need only cells with text in to be locked and the cells cells to be unlocked so people can still add data to the...