Auto Close

B

Bob Phillips

It can be done but it is not easy.

What you could do is to use the worksheet events, Change, SelectionChange
and Calculate, and ecah time one of these is invoked, set a timer. That
timer would call a rouine which closes the workbook.

See www.cpearson.com/excel/ontime.htm for details on the timer.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Dave Peterson

Just a question.

If the user spends 3 hours making changes, then has 10 minutes of idle time,
will you save or discard his changes?

If the user spends 3 hours making those changes, then has 10 minutes of idle
time, then realizes that he doesn't want to save those changes, will you save or
discard his changes?

This sounds like something that could get people pretty mad--no matter which way
you choose!
 
A

aaron.kempf

this type of Activity is much easier in ACCESS

you shouldn't use Excel for data entry in the first place
Access-- gosh-- get this-- multiple people can edit the same data at
the same time..

I MEAN WOW-- excel is for babies


-Aaron
 
B

boogie

Is it possible for an activesheet to close after 10 minutes of
idleness?Reason is if a user forgot to close his file, it will automatically
close down.
thanks
boogie
 
Top