How to make an Excel file save & close automatically after say 2 mins?

eurotrotter · 2011-09-09 08:05:19

hey gang, We have a problem with a file at work. The whole company accesses it and sometimes forget to close it, resulting in people not being able to access it since it is already open. Is there a way of setting up an excel file so that it saves and closes, so as to avoid this from happening? Thakns for your help, Ed

09-09-2011 09:05AM

#1

eurotrotter

Registered Users, Registered Users 2 Posts: 1,072 ✭✭✭

Join Date: June 2005

Posts: 378

hey gang,

We have a problem with a file at work.

The whole company accesses it and sometimes forget to close it, resulting in people not being able to access it since it is already open.

Is there a way of setting up an excel file so that it saves and closes, so as to avoid this from happening?

Thakns for your help,
Ed

0

Comments

#2 09-09-2011 09:31AM

Diddy Kong

Registered Users, Registered Users 2 Posts: 937 ✭✭✭

Join Date: November 2003

Posts: 862

Its possible, quick google came up with the solution - http://www.mrexcel.com/forum/showthread.php?t=46236

0