How do I limit excel to firing one bet

[ArticalBadboy]

Hello all,

I would like to fire an in-play bet into the market when the first selection drifts to a certain price.
To accomplish this I need all the formulas pre loaded for each selection, so the drift criteria will be activated on all (bar the eventual winner) during the event.
After that first bet has been placed, I don't want excel to fire any more bets.
How can I stop excel from firing more than once in the market.

Before anyone suggests to this through Guardian Automation, this MUST be done through excel.

Many Thanks

[EyePeaSea]

Before you place a bet, check a cell on the sheet (e.g. K5 isn't used by Guardian). If it's empty, then you can bet. Then when you bet, just write something into that cell to stop your code from placing another bet.

[ArticalBadboy]

Thank you, such a simple fix!