Closed Thread
Results 1 to 9 of 9

Kicking Inactive users by auto closing workbook

  1. #1
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    Office Pro 2010
    Posts
    275

    Kicking Inactive users by auto closing workbook

    Ok here's an unusual one that I need to know if possible.

    I have a current workbook that is active most of the day. What I need is a macro or something that autosaves the workbook, then closes it if left idol for a period of time, say 15 mins.

    Or another slant on this action, if the workbook is left idol for X time then some sort of cover sheet opens to hide the workbook until a password is entered, similar to a windows screensaver type action

    Please if anybodys got any answers or other suggestions please let me know

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    This link may help

    http://www.excelforum.com/showthread...=inactive+user

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    Office Pro 2010
    Posts
    275
    ok tried this and cant seem to get it to work...(not brilliant with macros)

    Any chance I could mail you the file so you can have a look. (Too much info / size to post)

  4. #4
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    Office Pro 2010
    Posts
    275
    Ok tried a few things and think i got it working now...all but one thing.

    On closing it asks if i want to save instead of autosaving and closing

    Did I miss something

  5. #5
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Try this example

    VBA Noob
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    Office Pro 2010
    Posts
    275
    Thanx for the help as always

  7. #7
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    No problem

    Code used

    In a normal module

    Please Login or Register  to view this content.
    In ThisWorkbook

    Please Login or Register  to view this content.
    VBA Noob

  8. #8
    Registered User
    Join Date
    12-02-2008
    Location
    England
    Posts
    1
    Hello, this is my first post.

    I use this code, but is there any way I can disable the warning without disabling the code?

    We all know it is going to close at work so we don't need the warning anymore, it is just an annoyance.

    Thank you.

  9. #9
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Quote Originally Posted by PeteGriggs View Post
    Hello, this is my first post.

    I use this code, but is there any way I can disable the warning without disabling the code?

    We all know it is going to close at work so we don't need the warning anymore, it is just an annoyance.

    Thank you.
    Please read the Forum Rules & start your own thread with a link to this one
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

Closed Thread

Thread Information

Users Browsing this Thread

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

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