Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Row = 4 And Target.Column < 5 Then With Target .Interior.Color = vbRed MsgBox "这个单元格严禁手工输入数据" & Chr(10) & "否则可能导致计算结果出现错误!" .Interior.ColorIndex = xlNone End With End If End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Row = 4 And Target.Column < 5 Then With Target .Interior.Color = vbRed MsgBox "这个单元格严禁手工输入数据" & Chr(10) & "否则可能导致计算结果出现错误!" .Interior.ColorIndex = xlNone End With End If End Sub