I wish to close an excel file automatically if there is no activity for 5 minutes. I have no knowledge how to go about it. I tried to find a answer on Internet but there is no clear answer.
Google for 'excel close idle timer'. There are multiple complete solutions out there. There's even a tutorial post on this: http://www.biz-development.com/Software&Utilities/9.6.Closing-Excel-File-After-Idle-Time.htm
This can be done in VBA. I had done this once before with a shared workbook, but could not find the code I used. What I did find is the following;
I tested it on my Excel 2010 and it works just fine.
Note: It is referring to the
Keep in mind macros need to be enabled for this to work. Also, the