| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Close Workbook
Could someone suggest some code that would automatically close a workbook if
there has been no activity (data entry, navigating between cells, changing worksheets etc.) in that workbook for 3 minutes? In conjunction with this, how can I ensure that other events in excel (such as an autosave promt) do not interfere with this procedure? I'm just learning to use VBA so please use small words and speak slowly! thanks for any advice. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically Close Workbook
See here for how to and why you might not want to.
http://www.officekb.com/Uwe/Forum.as...ter-10-Minutes Replace ThisWorkbook.Save with Application.DisplayAlerts = False ed wrote: Could someone suggest some code that would automatically close a workbook if there has been no activity (data entry, navigating between cells, changing worksheets etc.) in that workbook for 3 minutes? In conjunction with this, how can I ensure that other events in excel (such as an autosave promt) do not interfere with this procedure? I'm just learning to use VBA so please use small words and speak slowly! thanks for any advice. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200611/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically close second workbook | Excel Discussion (Misc queries) | |||
| automatically close second workbook | Excel Discussion (Misc queries) | |||
| Close form automatically upon opening workbook | Excel Discussion (Misc queries) | |||
| close without saving automatically | Excel Programming | |||
| Automatically close a userform | Excel Programming | |||
Linear Mode
