+ Reply to Thread
Results 1 to 2 of 2

Macro to auto-save and auto-close workbooks after a certain time?

  1. #1
    Forum Contributor
    Join Date
    01-16-2011
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Excel 2010
    Posts
    234

    Macro to auto-save and auto-close workbooks after a certain time?

    Hello!

    We have student workbooks to document training. Unfortunately, both students and instructors often forget to close the workbooks when finished, thereby making them inaccessible to anyone else on the network.

    Could a macro perhaps detect that there has been no keyboard activity for 10 minutes, and auto-execute a save and close?

    Thanks in anticipation!

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Macro to auto-save and auto-close workbooks after a certain time?

    http://excelribbon.tips.net/T008192_...nactivity.html

    The attached is a complete project based on another website.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. A macro to auto open and auto close a file with time schedule
    By billj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-21-2015, 06:01 AM
  2. [SOLVED] Auto Save/Close Workbook/File after x time inactivity
    By GijsWuyts in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-25-2015, 10:06 AM
  3. Auto open another WB and auto save and close
    By alfgrey in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-11-2014, 12:08 PM
  4. Can't edit macro with auto open and auto close.
    By lpete in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-03-2012, 07:25 PM
  5. conflict between auto save&close macro and show/hide sheets macro
    By alexandruc in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-18-2009, 11:56 AM
  6. Auto save and close workbook after user defined length of idle time
    By Nickster64 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-08-2008, 10:30 AM
  7. [SOLVED] Auto Excel workbook close: save= false during an auto subroutine
    By tomwashere2 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-16-2005, 02:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1