Help - Why did my vis basic formula stop working

[Kevin]

I wrote in last week and was helped with a vis basic
formula (see below). I went to add more numbers and it
appears to be not working since they are not showing up
on sheet 3 anymore. I checked all sources and all is the
same.I also copied and changed the sources to new cells
and that did not work. What happened? Did it shut itself
off somehow? When I reopened the excel file a "macro
security' message came on. Did that have any relevancy.

Thanks to all

Kevin


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$21" Then
Worksheets("Sheet3").Range("G4").Value = _
Worksheets("Sheet3").Range("G4").Value + Target.Value
End If
If Target.Address = "$A$22" Then
Worksheets("Sheet3").Range("G5").Value = _
Worksheets("Sheet3").Range("G5").Value +
Target.Valuermula which worked great (see below)

 

[Frank Kabel]

Hi
have you enabled macros on startup?. If not the code below is not
executed at all

 

[Guest]

Hi Frank - Once again thanks

-----Original Message-----
Hi
have you enabled macros on startup?. If not the code below is not
executed at all

--
Regards
Frank Kabel
Frankfurt, Germany


.