Seeking advice: Excel file keeps getting left open 1

[chilly442]

Looking for advice for the best solution:

I have an Excel file that users enter monthly data into. Users will leave the file open and then go to lunch, or leave for the weekend. So other users are not able to get into the file and do their work.

What is the best soluion to prevent or fix this problem?

How do you handle this problem?

I do not want them to save to a read only copy.

Do I write a macro that closes the file after it has been open for certain amount of time?



Thanks,
Chilly442
---------------------------------------
If I lived anywhere else I'd be Sunny442

 

[SkipVought]

Hi,

How about a shared workbook?

If you want to go the VBA route, you might use the Workbook_SheetChange event in the ThisWorkbook object, to set a timer when a worksheet change occurs. When the timer runs down, save and close the workbook.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]