View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default auto saving & closing file

On May 21, 2:32 pm, prtcorvette
wrote:
I would like to know if in excel ver. 2003 sp2 can I set a macro or any other
way to automatically after a given time of inactivity in the file save the
work completed and shut down and close a file so some one else can work with
it?


You could Share the workbook with the option to save every x minutes.
That way more than one can have it open and use it.