Change colour of data when changed

Hello
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)

End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 8
End Sub

Martin
©¿©¬

In VBE, Immediate window (Ctrl-G), type:
?application.enebleevents

If answer is false, type:
application.enebleevents=true

HTH
--
AP

<Martin ©¿©¬ @REMOVETHIS.plus.com> a écrit dans le message de news:
[email protected]...
> Hello
> 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)
>
> End Sub
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> Target.Interior.ColorIndex = 8
> End Sub
>
> Martin
> ©¿©¬

Maybe events are turned off. Go to the immediate window in the VBIDE and
type

Application.EnableEvents = True

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

<Martin ©¿©¬ @REMOVETHIS.plus.com> wrote in message
news:[email protected]...
> Hello
> 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)
>
> End Sub
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> Target.Interior.ColorIndex = 8
> End Sub
>
> Martin
> ©¿©¬

Thanks for your replies Ardus & Bob

I've found my problem
Enable macros was turned off, when I turned them back on my colour
changes began working again - happy days!!

Regards
Martin
©¿©¬