View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default Problem with Auto Close module

I have written code into a Workbook Open module.

Application.OnTime aTime2, Procedu="closeFile2"

the problem is, if I set it up to close after 1 minute but close it manually
before this time. It seems that after 1 minute even though the workbook is
close it executes above anyway and opens up the file again (and automatically
shuts it) - in a loop

I presume I am missing a lone of code that only executes above if the file
is open?

--
Kevin