Automatically Close Workbook

G

Guest

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 Workbook After 10 Minutes 4
Close file automatically 2
Suggest to close shared workbook 4
Auto Close Excel Workbook 2
Excel WorkBook Close Event 2
Excel2000: Closing an Excel workbook automatically 1
Workbook-Close StopTimer event 2

Top