Trigger Macro If System Is Idle for Certain Time.

Hello VJOSHI,

The attached workbook uses System Hooks (API) to monitor the keyboard and mouse. If either are moved the timer resets. Once the timer has expired, the workbook will save changes and close.

You can change the time in the Workbook_Open() event module. Here is the code.

Private Sub Workbook_Open()
    Call HookMouse
    Call HookKeyboard
    Call StartTimer(2 * 60)
End Sub

The red 2 indicates 2 minutes.