Re: Change colour of data when changed

Giganews Newsgroups
Subject: Re: Change colour of data when changed
Posted by:  Ardus Petus (ardus.pet…@laposte.net)
Date: Fri, 12 May 2006

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:
oas862l2of8ca0h34kgja1397urgphp6…@4ax.com...
> 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
> ©¿©¬

Replies

None

In response to

Change colour of data when changed posted by Martin ©¿©¬ @REMOVETHIS.plus.com on Fri, 12 May 2006