View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 279
Default Automatically Close Workbook

Could someone suggest some code that would automatically close a workbook if
there has been no activity (data entry, navigating between cells, changing
worksheets etc.) in that workbook for 3 minutes?

In conjunction with this, how can I ensure that other events in excel (such
as an autosave promt) do not interfere with this procedure?

I'm just learning to use VBA so please use small words and speak slowly!


thanks for any advice.