NessPJ
Active Member
- Joined
- May 10, 2011
- Messages
- 414
- Office Version
- 365
Hi all,
Does anyone know if it is possible to make a button on my excel sheet that will instantly stop all routines that are active?
I have a piece of code that also executes at a set interval of # minutes (posted below). This does not seem to stop when i press CTRL+Break. I have to run a routine with "Schedule:=False".
But i would also really like to add Button on my Excel sheet that allows the user to click it in case of 'emergency'. Is this possible?
Does anyone know if it is possible to make a button on my excel sheet that will instantly stop all routines that are active?
I have a piece of code that also executes at a set interval of # minutes (posted below). This does not seem to stop when i press CTRL+Break. I have to run a routine with "Schedule:=False".
But i would also really like to add Button on my Excel sheet that allows the user to click it in case of 'emergency'. Is this possible?
VBA Code:
RunWhen = Now + TimeSerial(0, RunInterval, 0)
Application.OnTime EarliestTime:=RunWhen, Procedure:=cRunWhat, _
Schedule:=True 'cRunWhat is a Public Const