Automatically Closing a Workbook

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hello,
Is there a way to automatically close a workbook that has been open for a
given time, such as 2 hours.

Thanks,

Bill
 
You could use an OnTime procedure. Chip Pearson has some very nice notes at:
http://www.cpearson.com/excel/ontime.htm

But it always worried me--do you save the workbook when you close it or discard
the last xx changes?

Either guess could be incorrect for the current user.

As a user, I think I'd be upset if you lost my changes or if you saved changes
that I didn't want saved.
 
Back
Top