VBA script stops when the workbook is not active.

Hello,

First, happy new year. I work in Excel with a VBA script. The purpose of my script is that every 5 seconds a procedure will be executed. This works well.

If my workbook is not active, it does not work. Or when I work with another workbook. Or when I work with another program. Then the script will stop to execute. It looks like a break.

I have tried several scripts that have the same effect. I want the script continues normally with execution.

Please Login or Register  to view this content.

Can someone give me a solution?

I have asked this question on the following link: http://www.mrexcel.com/forum/showthr...=1#post2168007


Thanks so much!

grid

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save