Automatically Close Workbook

E

ed

Could someone suggest some code that would automatically close a workbook if
there has been no activity (data entry, navigating between cells, changing
worksheets etc.) in that workbook for 3 minutes?

In conjunction with this, how can I ensure that other events in excel (such
as an autosave promt) do not interfere with this procedure?

I'm just learning to use VBA so please use small words and speak slowly!


thanks for any advice.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I alter this AutoSave code? 1
Close Code possible? 3
Excel crashing when trying to close a workbook 0
Suggest to close shared workbook 4
Close Workbook After 10 Minutes 4
Close file automatically 2
auto-protect a sheet upon workbook close 4
Split workbook into multiple workbooks 2

Top