View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Close Code possible?


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