how to use excel stopwatch without impact on other excel

Hi, recently i created a stopwatch in excel. however, the timer stop whenever i edit other column in same excel or edit in other excel. how can i avoid this?
Please help.

I code in Modules.

Please Login or Register  to view this content.

thanks and looking forward for solution.

There is nothing in the code you showed us that would cause this. The timer should persist no matter what you are doing in the user interface. You have a sub called StopTimer1. Is it called from anywhere in other code in the same file? If so, that is probably what is causing it to stop.

It would help if you attached your file so we can reproduce the behavior.

@dummyfella101, does the timer actually stop or does it merely pause whilst the application interrupt works (which it is meant to do to enable your other op to take place) then it should catch up the paused time.
I have upload a couple of apps showing this (the clock merely stops updating but then register correctly when it has the application back), I believe the only way you can overcome this is by multi interrupts of the API which is likely to be unstable.
Does it affect your app operation or is this just aesthetically displeasing .

You seem to exposed another MicroSoft idiosyncrasy, I have never had occasion to work with two workbooks open and a timer running.
This appears to be a necessity of the system interrupt to be able to interrogate the keyboard input.
However I think I understand your requirement (i.e. to have a means of recording the lapsed times of several tasks at the same time).
Have a look at the attached file it utilises input from the system clock, records individual start and finish times and calculates the time differences.