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/