Hi,

I've created a workbook that has an auto-close facility. After 5 mins of
inactivity a userform is displayed with a countdown of 10 seconds before the
workbook closes without saving changes. This has worked perfectly until now.

I want to have another workbook with this auto-close facility. The problem
arises when they're both open and one starts counting down while the other is
counting down. When the userform from the second workbook is displayed, it
freeze and stops the code of the userform from the first workbook.

Is there any way of running the userforms of each of these workbooks
simultaneously??

Any help much appreciated.

Did you open the userforms as modeless? (requires xl2000 or later).

--
Regards,
Tom Ogilvy

"Libby" wrote in message
...
Hi,

I've created a workbook that has an auto-close facility. After 5 mins of
inactivity a userform is displayed with a countdown of 10 seconds before
the
workbook closes without saving changes. This has worked perfectly until
now.

I want to have another workbook with this auto-close facility. The problem
arises when they're both open and one starts counting down while the other
is
counting down. When the userform from the second workbook is displayed,
it
freeze and stops the code of the userform from the first workbook.

Is there any way of running the userforms of each of these workbooks
simultaneously??

Any help much appreciated.