|Subject:||Change colour of data when changed|
|Posted by:||Martin ©¿©¬ @REMOVETHIS.plus.com|
|Date:||Fri, 12 May 2006|
I have been using the code below in my worksheets to change the colour
of updated/edited data.
Now it doesn't seem to be working
Any ideas why?
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 8