VBA Code - Excel On Worksheet Change

[backfromthebush]

Hi,

I've written some code that when a value changes in column B, it will call another procedure. What is bugging me is that it worked to start with, and now it doesnt!!! Can anyone help?!! The called procedures work, but i cant get the "Worksheet_Change" procedure to work now!! AHH!

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("B:B")) Is Nothing Then
        '...change made in column B
    Call DefaultPlayerNull
    Else: Exit Sub
    End If
End Sub
Sub DefaultPlayerNull()
    If ActiveCell.Value = "**Available**" Then
        ActiveCell.Offset(0, 1).Value = Null
        Else: Call PlayersSelectedPos
    End If
End Sub

 

[AlphaFrog]

Did you at some point when writing your code use....
Application.EnableEvents = False
...and then had a code error leaving the events turned off?

If yes, then reload your workbook or run this in its own macro
Application.EnableEvents = True

 

[backfromthebush]

Thanks mate.. worked a charm!