software

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

lt;Martin ©¿©¬ @REMOVETHIS.plus.comgt; a écrit dans le message de news:
...
gt; Hello
gt; I have been using the code below in my worksheets to change the colour
gt; of updated/edited data.
gt; Now it doesn't seem to be working
gt;
gt; Any ideas why?
gt;
gt; Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
gt;
gt; End Sub
gt;
gt; Private Sub Worksheet_Change(ByVal Target As Range)
gt; Target.Interior.ColorIndex = 8
gt; End Sub
gt;
gt; Martin
gt; ©¿©¬
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)

lt;Martin ©¿©¬ @REMOVETHIS.plus.comgt; wrote in message
news
gt; Hello
gt; I have been using the code below in my worksheets to change the colour
gt; of updated/edited data.
gt; Now it doesn't seem to be working
gt;
gt; Any ideas why?
gt;
gt; Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
gt;
gt; End Sub
gt;
gt; Private Sub Worksheet_Change(ByVal Target As Range)
gt; Target.Interior.ColorIndex = 8
gt; End Sub
gt;
gt; Martin
gt; ©¿©¬
Thanks for your replies Ardus amp; 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
©¿©¬