Auto Close

  • Thread starter Thread starter Bob Phillips
  • Start date Start date
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)
 
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!
 
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
 
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
 
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
Click to expand...

You have received the solution to all of your Excel
woes. You have nothing useful to contribute here.
Into the bozo bin you go.
 
Back
Top