View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Multiple workbooks

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.