hello is any one can give me solution, how to protect sheet immediate enter the value.pls help
pls use this code to protect sheet cell.
Private` Sub Worksheet_Change(ByVal Target As Range)
Dim cel As Range
ActiveSheet.Unprotect ‘ Password:=”secret”
For Each cel In Target
If cel.Value “” Then
cel.Locked = True
ActiveSheet.Protect ‘ Password:=”secret”
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.