|
qinhuan66 发表于 2014-1-20 09:51
老师又打扰你了,用了你的代码非常好用。但使用过程中发现了一个问题,就是当不在代码Range("c14:c25,g14 ... - Private Sub Worksheet_Change(ByVal Target As Range)
- With Sheets("个人缴费卡片")
- Dim rng
- For Each rng In Target
- If Intersect(rng, Range("c14:c25,g14:g25,k14:k25,o14:o25,s14:s25,c31:c42,g31:g42,k31:k42,o31:o42,s31:s42,c48:c59,g48:g59,k48:k59,o48:o59,s48:s59,c65:c76,g65:g76,k65:k76,o65:o76,s65:s76,c82:c93,g82:g93,k82:k93,o82:o93,s82:s93")) Is Nothing Then
- Exit Sub
- Else
- If CStr(rng.Value) = rng.Formula Then
- .Unprotect ("695360052")
- With rng.Font
- .Color = vbRed
- .Bold = True
- End With
- .Protect ("695360052")
- End If
- End If
- Next
- End With
- End Sub
复制代码 不知道为啥,格式都没了。。你自己调整下吧。。。-。- |
|