Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Uninstall Add-ins when workbook closes | Excel Programming | |||
Esc Key Closes Workbook | Excel Programming | |||
Run Auto Close when Excel Closes | Excel Programming | |||
protect add-in after workbook closes | Excel Programming | |||
Timer for auto shut down | Excel Programming |