Results 1 to 7 of 7

Use of 'on time' to kick inactive users

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-28-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    187

    Use of 'on time' to kick inactive users

    A fairly hackneyed question this, with quite a lot of literature available on the web, but nothing that answers my specific question.

    I use the 'on time' function to kick users out of a shared workbook after 30 minutes of inactivity (i.e. no cells updated). Technically it works, as it does kick out the users.

    However the time after which it does so seems to bear no relation to the time I have instructed. Sometimes shorter, sometimes longer! If it is was always longer, I would be happy that there is an error in my code somewhere (i.e. the time value is resetting on an unexpected event that I need to find and alter). But shorter: that really stumps me.

    I'm sure it's something rather straightforward, but I'd be most grateful for any ideas!
    Last edited by TKCZBW; 04-16-2014 at 02:08 AM. Reason: Grammar error

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Kick out Inactive users except in read only
    By StephanieLilly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2013, 02:16 PM
  2. Kick Access users out via Excel VBA
    By GeorgY in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2009, 02:22 PM
  3. Kicking Inactive users by auto closing workbook
    By ukphoenix in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-02-2008, 03:43 PM
  4. versions:Kicking Inactive users by auto closing workbook
    By Nyanko in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2007, 10:23 PM
  5. Kick Users Out of Sheet
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2007, 05:34 AM

Tags for this Thread

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