Hi All,
Have any of you had issues trading football with the multiple spreadsheet going suspended before the start of a match?.
I've been using it a bit this weekend, and thought that I could set my events pre KO, then let it run. However, as soon as the match kicks off, the Market goes SUSPENDED, then INPLAY, and the STATUS field is stuck with MARKET_SUSPENDED, meaning I have to be there to remove it and allow my bets to become active.
This has happened a number of times, and means that I either need to be there at the start of every event, or write some conditional VBA to get around the problem.
Any similar experiences or suggestions as to how to circumvent?
-Steve
Issues at start with SUSPENDED using multiple spreadsheet
Hi Guys.
Not sure what cell the "MARKET_SUSPENDED" appears in, but something along these lines should help (change A1 to whatever value you need).
This code needs to go into the individual sheet, NOT a module.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("a1") = "MARKET_SUSPENDED" Then
Range("a1").ClearContents
End If
End Sub
If you want the same effect over several sheets, you'll have to put it in "This Workbook"
Any problems, get back, I'll try to help.
Nigel.
Not sure what cell the "MARKET_SUSPENDED" appears in, but something along these lines should help (change A1 to whatever value you need).
This code needs to go into the individual sheet, NOT a module.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("a1") = "MARKET_SUSPENDED" Then
Range("a1").ClearContents
End If
End Sub
If you want the same effect over several sheets, you'll have to put it in "This Workbook"
Any problems, get back, I'll try to help.
Nigel.