LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Question on VBA : how to detect "idle" condition

Hi everybody,

I have this Excel worksheet, associated with a "Auto Open" macro. After this
macro has performed the few tasks it is designed for, the user is then free
to enter whatever he wants to in the spreadsheet.

I would like to automatically save the worksheet and exit Excel if there is
no activity (i.e. if the user doesn't move the mouse, press a key,
anything...) at a given time, after the macro has done it's job.

Is there a simple way to do this ? For instance, would the solution consist
in detecting that there is not change whatsoever on the Excel screen and
Exit after a counter has elapsed , whilst letting the user react at any time
?
(sorry about my lousy English, guys).

Could someone suggest a few lines of code I could try ?

Many thanks in advance for your time and kind help.
BRGDS,
Daniel





 
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
problem getting "detect and repair" to work in Excel 2003 ms Excel Discussion (Misc queries) 4 February 4th 10 02:39 AM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
"Disk is Full" add-on question to "Can't reset last cell" post tod [email protected] Excel Discussion (Misc queries) 0 January 22nd 07 02:32 AM
Question on determining "ROW" inside of a "For .. RANGE " loop David Schrader[_2_] Excel Programming 2 January 3rd 07 08:18 PM
Validation question - allow -500%, 0%, "=50%*50%" but forbid "A", "", " ", "-" ? tskogstrom Excel Programming 2 November 27th 06 09:50 AM


All times are GMT +1. The time now is 06:32 AM.

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

About Us

"It's about Microsoft Excel"