[Quote=引用 4 楼 hong1987 的回复:]
引用 3 楼 dlmeijianyu 的回复:
给个例子,如果是选择[C5:F6]当中的某个单元格,则弹出一个对话框,
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row >= 5 And Target.Row <= 10 And Target.Column >= 3 And Target.Column <= 6 Then
MsgBox ("不可写入")
Range("A1").Select
End If
End Sub
[Quote=引用 3 楼 dlmeijianyu 的回复:]
给个例子,如果是选择[C5:F6]当中的某个单元格,则弹出一个对话框,
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row >= 5 And Target.Row <= 10 And Target.Column >= 3 And Target.Column <= 6 Then
MsgBox ("不可写入")
Range("A1").Select
End If
End Sub
[/Quote]
给个例子,如果是选择[C5:F6]当中的某个单元格,则弹出一个对话框,
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row >= 5 And Target.Row <= 10 And Target.Column >= 3 And Target.Column <= 6 Then
MsgBox ("不可写入")
Range("A1").Select
End If
End Sub