Excel Idle Time Close

There is no option within Excel to automatically time out. Windows itself has a time out facility - by using a screen saver and setting the on resume display welcome screen item (in XP) you can force users to re-login when there has been no activity on the PC.

For Excel in particular, you could set up code to detect when the Workbook has been inactive. Try the following ....

Copy and paste the following into the ThisWorkbook module -

Option Explicit

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
ResetTimer
End Sub

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
ResetTimer
End Sub

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
ResetTimer
End Sub

This simply checks whenever the workbook is active and resets a timer.

Then copy and paste the following into a user module -

Public CloseDownTime As Variant

Public Sub ResetTimer()
On Error Resume Next
If Not IsEmpty(CloseDownTime) Then Application.OnTime EarliestTime:=CloseDownTime, Procedure:="CloseDownFile", Schedule:=False
CloseDownTime = Now + TimeValue("00:00:30") ' hh:mm:ss
Application.OnTime CloseDownTime, "CloseDownFile"
End Sub

Public Sub CloseDownFile()
On Error Resume Next
Application.StatusBar = "Inactive File Closed: " & ThisWorkbook.Name
ThisWorkbook.Close SaveChanges:=True
End Sub

Change the green highlighted part "00:00:30" above to whatever interval you need (currently this is set for 30 seconds).

The Application.StatusBar = item is optional - it simply leaves a message for the user at the bottom of the Excel screen, which will remain until Excel is closed down and re-started.

Mettegaga, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.