Excel vba close workbook after inactivity

[vaneagle]

Hi,

I assume its possible with vba but not sure how to go about it.....

I need a workbook to close after a period of say 5 minutes of inactivity. Sometimes the user will go into the file and forget about it when other users need to use it!

does anyone have any code or suggestions?

vaneagle

[royUK]

You would need to use VBA,


First of all set a time limit eg 5 minutes

Please Login or Register  to view this content.

This resets the timer if a change in the workbook occurs

Please Login or Register  to view this content.

If no changes have occurred then this runs

Please Login or Register  to view this content.

[vaneagle]

I must be missing something.....

Am I posting this in the module or ThisWorkbook??

As it doesn't seem to work for me...

Maybe its because its I have a 'Auto_Open()' sub as well?

[boylejob]

vaneagel,

Refer to this post.

http://www.excelforum.com/showthread.php?t=600315

This was posted a few days ago by royUK and it tells you where each section of code goes. You will actually be putting code in the ThisWorkbook, the Sheets, and the standard modules. Code must be put in all three places to get this to work. I have tried it and it works beautifully.

Hope this helps!

[vaneagle]

You are correct!!

It works great thanks All for your help!!

[vaneagle]

Update:

For some reason the file once it is closed is reopening again..

ie enable macros then the file pops up for a few seconds then closes again...

weird....

the zip file from this post:

http://www.excelforum.com/showthread.php?t=600315

does it as well....

[mikerickson]

Add this right after the End With in Sub closeWB

Please Login or Register  to view this content.

[Cyberpawz]

Add this right after the End With in Sub closeWB

Please Login or Register  to view this content.

I hate to ask, but what does this do? it looks like it sets the time value to 5:00 PM?

[mikerickson]

It turns off the next OnTime event

[SHuKoSugi]

Noticed this code will not effect let say I edit or insert a comment in a cell and idle...it will not save and close but remain open...any idea? thanks.