Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inactive close
Is there any way to have excel close down after a set
time of being inactive? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inactive close
Dave,
Plagiarized from a previous post by Tom Ogilvy............... For reference, a Google search of "Inactivity Timeout" brought it right up. John <snip In the ThisWorkbook code module: Public BootTime As Date ' Tom Ogilvy 8/18/99 Private Sub Workbook_Open() BootTime = Now + TimeValue("00:30:00") Application.OnTime BootTime, "CloseBook" End Sub Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range) Application.OnTime BootTime, "CloseBook", , False BootTime = Now + TimeValue("00:30:00") Application.OnTime BootTime, "CloseBook" End Sub In a General Module Sub CloseBook() ThisWorkbook.Save ThisWorkbook.Close End Sub <snip Dave Hardy wrote: Is there any way to have excel close down after a set time of being inactive? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Inactive | Excel Worksheet Functions | |||
why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
Option in Excel to save a close a workbook inactive for 5 minutes | Excel Discussion (Misc queries) | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel |