View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default inactive worksheet

Peter,

What if there's no one there to see the pop-up?

Why not use an inactivity timer and close it down automatically.
You can find some code for one he

http://tinyurl.com/5k2ydn

John

"Looping through" wrote in
message ...
Is there a way to have a pop up notice appear if a open workbook is open
but
no information is being inputed or no cells are being activated or tabs
being
selected?

Basically tell the current user to close the workbook due to inactivity.

I have a shared file that sometimes get's left open on someone computer
and
that person moves on to other tasks without closing it.

Is this possible?
TIA
Peter