Macro wont stop running

[lorenzoc]

Hey guys,

any help would be fantastic.

I simply want to run a macro based on a variable whenever the sheet is activated. All the individual macros below work fine when ran alone. However, when I put them into the code below, it seems they keep running or run over and over until I get an error. Here is the code:

Private Sub Worksheet_Activate()
Set Target = Range("A4")
If Target.Value = "Player1" Then
Call golf3
End If
If Target.Value = "Player2" Then
Call golf4
End If
If Target.Value = "Player3" Then
Call golf6
End If
If Target.Value = "Player4" Then
Call James
End If
End Sub

any idea why they work individually but break or repeat when using the above code?

really appreciate any help

 

[wideboydixon]

You may be triggering the Activate event again in one of those macros. Try using:

Application.EnableEvents = False

At the start of the Sub and then turning events back on (= True) at the end.

WBD