Save and Close Timer

**yawnzzzz** · 06-17-2009, 10:05 AM

I have a workbook that is going to be placed on a server where a large amount of people will need access to it. I've read that the 'sharing' in Excel tends to cause the file to become corrupt, so I'd like to avoid that outcome.

Since, only one user will be allowed into the workbook at a time, I'd like to write code that kicks the user out after a certain amount of time. The code would have a timer that starts when they open the workbook and at the 30 minute mark, it saves and closes the workbook. (I'll probably put some code in there where they can cancel the operation as well.)

I've used everything previously except for a timer, so if someone could give me an example of a timer it would get me rolling.

**yawnzzzz** · 06-17-2009, 10:10 AM

Just found a great reference on this matter here:

http://www.cpearson.com/excel/OnTime.aspx

**romperstomper** · 06-17-2009, 10:12 AM

To run a procedure after 30 minutes, you can use OnTime:

Please Login or Register  to view this content.

You need to make sure that the schedule is cleared when closing the workbook:

Please Login or Register  to view this content.

in case the user closes before the macro is scheduled to run, otherwise the workbook may be reopened to run the macro.

**yawnzzzz** · 06-17-2009, 10:26 AM

Is there a way to put a Yes/No box on a timer? So that if a user doesn't answer, "Yes', in 30 seconds it will assume "No".

**romperstomper** · 06-17-2009, 10:49 AM

Yes - see the code here for example. Or you could use a userform.

**yawnzzzz** · 06-17-2009, 11:00 AM

Please Login or Register  to view this content.

I found this code here:
http://www.pcreview.co.uk/forums/thread-947406.php

It works great for a messagebox pop-up, but I'm unsure of how to check the value.