View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hardhit Hardhit is offline
external usenet poster
 
Posts: 1
Default Autoclose excel file after x minutes of inactivity

Hello,

Is there a possibility to automatically close an excel file after for
example 5 minutes of inactivity on the file ?

We have at our company for each department a file in which they need to fill
in production data. 2 times per day this data is collected into an overview
file.
But I often have to call the departments to ask them to close the file so
that I can run the collection macro's.

Regards,
Peter