Typo:

If Target.Value = "Purchase" Then Call Macro1
If Target.Value = "Sales" Then Call Macro2
Application.EnableEvents=True

--
Tim Williams
Palo Alto, CA


"Tim Williams" wrote in message
oups.com...
Without knowing the exact code you're using it's difficult to suggest
anything else.

The modification to Jim's code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
Application.EnableEvents=false
If Target.Value = "Purchase" Then Call Macro1
If Target.Value = "Sales" Then Call Macro2
Application.EnableEvents=false
End If
End Sub


WTF??

Sometimes it is working, sometimes it is not working....
*FRUSTRATED* :(


--
Infinity