I have a Workbook which is Save in the NetWork. It allows only 1 user at a time to open by
[vba]
Private Sub Workbook_Open()
If ThisWorkbook.ReadOnly Then
ThisWorkbook.Saved = True
ThisWorkbook.Close SaveChanges:=False
End If
End Sub
[/vba]
My problem now is most of the time user forget to close the workbook then leave the office which made the file in use for the whole day. Is there any solution to AutoClose the WorkBook when it is Idle or can I set a user to to use the file for 15 minutes only.