技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 934
|
即使用工作表事件還是可以保留復(fù)制剪貼的功能,如下代碼- Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal target As Range)
- If Application.CutCopyMode <> False Then
- Application.CutCopyMode = False
- Call ColorBand(target)
- End If
- End Sub
- Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal target As Range)
- If Application.CutCopyMode = False Then
- Call ColorBand(target)
- Else
- Exit Sub
- End If
- End Sub
- Private Sub ColorBand(ByVal rngTarget As Range)
- On Error Resume Next
- [ChangeColor].FormatConditions.Delete
- rngTarget.EntireRow.Name = "ChangeColor"
- With [ChangeColor].FormatConditions
- .Delete
- .Add xlExpression, , "TRUE"
- .Item(1).Interior.ColorIndex = 17
- End With
- End Sub
復(fù)制代碼 只是,如果是用條件格式方式,將會(huì)刪除原有的所有條件格式
對(duì)用戶來是不是最好的選擇。 |
|