View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Libby Libby is offline
external usenet poster
 
Posts: 151
Default Multiple workbooks

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.