Automatically Close Workbook
 

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.

Automatically Close Workbook
 

See here for how to and why you might not want to.
http://www.officekb.com/Uwe/Forum.as...ter-10-Minutes


Replace ThisWorkbook.Save with Application.DisplayAlerts = False

ed wrote:
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1