Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False '禁止触发连锁事件 If Not Application.Intersect(Target, [c5:g13]) Is Nothing Then Target.NumberFormatLocal = """*****""" & ";" & """*****""" & ";" & """*****""" & ";" & """*****""" '设置星号格式 End If Application.EnableEvents = True '允许触发连锁事件 End Sub 楼主试试 |