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
.