Hello,
i have a macro that once every second reads all the rows in a worksheet,
does some comparisons and when the comparisons have success it shows a
simple form. [The data inside the sheet come from a DDE link in real time]

The problem is that when this macro is running (it keeps running in loop
with a 1 second pause [with a small loop with doevents] between each
loop) i cannot switch to a different XLS file.

Let me explain better...
lets say that i have two XLS files open at the same time... they have
their own "button" on the taskbar, clicking one of them i can switch
from one XLS file to the other...

Ok... this works... but NOT when the macro is running on the first XLS
file. In some way, when i click on the taskbar button of the second XLS
file, the focus goes back automatically to the first XLS file.

Inside the same XLS file, thanx to the doevents, i have no
restrictions... i can change worksheet, change cells, etc... all this
while the Macro is running... the problem happens only when i have more
than one XLS file open and want to switch to the other XLS file.

Thanx,
Luca