Cannot Open New Spreadsheets While Stopwatch Macro is Running

[isabela1214]

I am stumped on how I can fix my macro to allow other spreadsheets to be opened while I run my macro for a stopwatch in the background. The purpose of this stopwatch is to time how long it takes to complete other tasks so it is pivotal to be able to run other spreadsheets. Any help would be appreciated!

[Leith Ross]

Hello isabela1214,

Without seeing your code I can't be sure this will work but give it a try.

At the beginning of your Stopwatch macro add the following statement:

Please Login or Register  to view this content.

This should allow the macro to yield to other system processes and inputs.

[isabela1214]

Hello isabela1214,

Without seeing your code I can't be sure this will work but give it a try.

At the beginning of your Stopwatch macro add the following statement:

Please Login or Register  to view this content.

This should allow the macro to yield to other system processes and inputs.

Thanks Leith.
Here is my code. Where should I insert your suggestion?

Please Login or Register  to view this content.

[Tim l]

Hi All, why not have a macro button to stamp time (Now) for the start then at the end another button to stamp "Stop", then a formula to calculate the difference, by doing this no macro is running