Works fine thanks.

Is it possible to modify this so it closes excel and the file rather than
just the file?

Thanks

"Chip Pearson" wrote:


I have code to do that at http://www.cpearson.com/Excel/TimedClose.htm

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Fri, 24 Apr 2009 07:11:02 -0700, LiAD
wrote:

Hi,

I have a workbook with three sheets in it. Is it possible to create a code
that will automatically save and close the file after 5 minutes of no
usage/activity?

The file is used to record deliveries, the user is just hittin macro buttons
which either add one or subtract one from each product type as they are
delivered and consumed.

Could anyone help me with a code please?

Thanks
LiAD