Automatically Save And Close Workbook After Period Of Inactivity

I have a workbook that gets viewed/edited on different computers throughout our shop, and the situation often arises where someone forgets to close the workbook after they are done with it, which means if someone else at a different station tries to open it, they aren't able to do any editing.

I'm wondering if a way I could solve this problem would be by having the workbook automatically save and close after two minutes of inactivity. I don't know if Excel supports this kind of function, but that's why I'm asking.

Any ideas?

Alright, thanks, that's definitely a big help - however, it only works as long as the dude who opened the workbook actually clicks somewhere first. Is there a way to make the workbook start the countdown once it's opened?

see if it helps you

That certainly helps with closing the workbook, but it closes within thirty seconds of opening it even if there is activity.

just removed the '

Please Login or Register  to view this content.

Thank you both, rvasquez, I removed the message prompt, so perhaps that is why I need to click somewhere first to start the countdown.

john55, that fixed that problem; however, the workbook doesn't automatically save now.

I'm trying to figure out the best way to combine these two codes into one, I've attached both examples to demonstrate what I described above.

That does it! Sweet, thank you so much.

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

Wedge120,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

protonLeah,
No disrespect intended, but my question is simply about the code that the original poster is now using for his problem.

The original poster received help from member rvasquez. I am asking for a little bit if "dissecting" of his code, if you will. I do not see how starting a new thread about this code benefits the forum more than having a constructive discussion in the thread from which it sprang.

Maybe you misunderstood my question?


edit: I guess the wording of my question lead you to believe I was asking about how to copy and paste code? I am sorry, that was not the intent of my question. I simply wanted to know how the code works, not how to copy and paste code into modules. Sorry for the confusion.

Hello mrdude70 and Wedge120, I am not the most proficient at Excel coding, but let me see if I can help you out here.

I just followed these steps to create another working copy of this code (and I changed the time value to 30 seconds to give you a bit more time to work with):

1. Create and save a new Excel document as an Excel Macro-Enabled Workbook.
2. With the new workbook open in Excel, press the Alt & F11 keys simultaneously.
3. Ensure your Project Explorer is open - if it isn't, press the Ctrl & R Keys at the same time. Its default location for me is the left side of the screen.
4. Right click the Excel document title in the Project Explorer and choose Insert/Module.
5. Double-click the newly created module (the default name is Module1) to open its window.
6. Copy and paste this code into Module1:

Please Login or Register  to view this content.

7. Double-click the ThisWorkbook icon in the Project Explorer and paste this code into its window:

Please Login or Register  to view this content.

8. Switch back to your Excel file (Alt & F11), save and close.

When you open your Excel file again and do nothing for 30 seconds, it should save and close automatically. All the best!

phas21, unfortunately I'm not sure how to do that, but I'm sure if you directly contacted one of the gurus who solved my issue (as I don't think they are monitoring this thread anymore), they would be happy to help you out.