Usually, when you first start Excel, a pop-up will ask if you want the macros
enabled or not..........just indicate affirmative.

In Excel97, Tools Options GeneralTab uncheck the box for "Macro Virus
protection"

In other versions it may be under Tools Macros, or Tools Security

hth
Vaya con Dios,
Chuck, CABGx3



"Martin ©¿©¬ lid" wrote:

I'm getting messages that the macros are disabled
How do I enable them?
--
Martin
©¿©¬

On Thu, 7 Dec 2006 07:12:01 -0800, CLR
wrote:

The code appears to work fine, as written, but will only perform on the one
sheet where it's installed.......if you want it to work on other sheets, it
must be copied to their code sections as well..........

Vaya con Dios,
Chuck, CABGx3




"Martin ©¿©¬ lid" wrote:

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