View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Shared workbook inactivity warning

The basic code would be found at Chip Pearson's site
http://www.cpearson.com/excel/ontime.htm

You would cancel the ontime in the workbook level selection change event and
schedule a new one 5 minutes hence.

http://www.cpearson.com/excel/events.htm

if you are not familiar with events.

John Walkenbach has code for playing a sound:
http://j-walk.com/ss/excel/tips/tip59.htm



--
Regards,
Tom Ogilvy

evillen wrote in message
...

I will be very grateful if someone can suggest to me the neatest way to
achieve the following:

I want a visible warning and/or audible alarm to popup after five
minutes of inactivity within a workbook session.

The reason for this is that a number of users need to enter data into a
'common' index folder, often users will have finished entering their
data but have left the workbook open, consequently forbidding write
access to anyone else.

Many thanks
Len


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/