Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Inactive close

Is there any way to have excel close down after a set
time of being inactive?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 550
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find Inactive Krish Excel Worksheet Functions 6 December 1st 06 02:52 AM
why do all excel worksheets/workbooks close when I close one? Penny Excel Discussion (Misc queries) 1 November 29th 06 03:49 AM
Option in Excel to save a close a workbook inactive for 5 minutes Patricia Peterson Excel Discussion (Misc queries) 4 January 5th 06 05:00 PM
Excel shoud not close all active books when clicking close button technomike Excel Discussion (Misc queries) 0 June 10th 05 05:35 PM
excel - Windows close button (x) should only close active workboo. CoffeeAdict Setting up and Configuration of Excel 3 February 8th 05 04:30 AM


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"