Change colour of data when changed

M

Martin ©¿©¬

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
©¿©¬
 
A

Ardus Petus

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

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

HTH
 
B

Bob Phillips

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

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
©¿©¬
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change colour of cells when content is altered/changed 5
Conditional formatting in VBA not working 3
Change colour of cells when content is altered/changed BUT NOT TO INSERTED OR DELETED ROWS 3
please help.is it possible re-edit macro to convert text like1530-2200 to time format automatically? 1
Cell Protection 1
Using Excel VB, Update a specific cell, on any change of anotherspecific cell 2
macro for Tab colour change 3
Conditional formating VBA to aply to the entire sheet? 4

Top