Can I allow users limited time to edit spreadsheet

[Melanie]

I have a spreadsheet that is placed on a share drive and
a lot of people have access to it and many must edit
information. The problem we're having is they're all
trying to get in the file at the same time and some open
the file and leave it open for a long time. This keeps
others from being able to input their information. Is
there a way to set a time limit as to how long you can
keep a file open so that nobody accidentally leaves the
file open? Thanks!

 

[Jason Morin]

This will close the wb after 5 min. Press Alt+F11, Insert

Module, and paste in the code below:

Sub Auto_Open()
Application.OnTime Now + TimeValue("00:05:00"), "Closeit"
End Sub

Sub Closeit()
With ActiveWorkbook
.Save
.Close
End With
End Sub