View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Martin ©¿©¬ [email protected] Martin ©¿©¬ somewhere@in-time.invalid is offline
external usenet poster
 
Posts: 5
Default Change colour of cells when content is altered/changed

Hi
I have a number of worksheets where the cell colour used to change to
Blue when an entry was made or edited
But it ain't doing it any more
--------------------------------------
This is the code

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 8
End Sub
-------------------------------------------------
I didn't write the code, more likely someone created it for me
Would anyone know why the above code has stopped working
and how to fix it please ?
--
Martin
©¿©¬