Timer that auto-closes workbook?
 

Is it possible (or even wise) to automatically close and
save a workbook after a couple minutes of idle time???
If so, how would you implement the timer?

thank u

Timer that auto-closes workbook?
 

Hi,

Is it possible

Yes have a look here
http://www.ozgrid.com/forum/showthread.php?t=42169

Is it wise

Only you can decide. In this portion of the code I've pointed you to you
will need to make a decison, Save or Not Save

Sub CloseMe()
Application.DisplayAlerts = False
ThisWorkbook.Close savechanges:=True ' or false, you choose
Application.displayalerts = True
End Sub

If you don't save what are you discarding=danger
If you do save what garbage are you keeping=danger
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Robert Crandal" wrote:

Is it possible (or even wise) to automatically close and
save a workbook after a couple minutes of idle time???
If so, how would you implement the timer?

thank u

.