第2问代码:两个事件 Private Sub Worksheet_Change(ByVal Target As Range) If Target.Value <> "" Then ActiveSheet.Unprotect Target.Locked = True ActiveSheet.Protect End If End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Value = "" Then ActiveSheet.Unprotect Target.Locked = False ActiveSheet.Protect End If End Sub
|