Need To Stop my Excel Sheet Triggering Bets

[Captain Sensible]

Can't see any major problems why the code shouldn't work, I'm assuming you're not playing horse racing as obviously any contents in A10 will always be overwritten by the runners details if the field is large enough. As all three sheets are being linked to the same market just use one instance of vba to set all three sheets -> something like this should be sufficient in the first sheet.

I'm assuming the sheets are still called Sheet1, Sheet2 etc if not amend those details. Also if you're doing markets other than racing and the markets don't have more than 5 selections change the range cell back to your A10 otherwise using AA1 would be a lot wiser option as a control cell.

Private Sub Worksheet_change(ByVal Target As Range)
If Target.Columns.Count <> 16 Then Exit Sub
Application.EnableEvents = False

If Sheets(1).Range("F2") = "Suspended" Then
Sheets(1).Range("AA1") = "No"
Sheets(2).Range("AA1") = "No"
Sheets(3).Range("AA1") = "No"
End If


Application.EnableEvents = True
End Sub

[Captain Sensible]

personally if I were trying to stop betting In Play I'd be monitoring the "In Play" indicator rather than the Suspended as it'd be more reliable but I'm guessing you must have some reason for using suspended indicator