+ Reply to Thread
Results 1 to 4 of 4

Allow others to Edit, but be able to kick them out.

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2016 Office 365 64-Bit
    Posts
    3,419

    Allow others to Edit, but be able to kick them out.

    I made a workbook which a coworker and I both access. We both need to be able to edit it, but she has a bad habit of leaving it open when she leaves for the day (my fault for making such a useful tool!). I don't have this set as a SHARED workbook (too many limitations on the things we have to do with this WB), so how would I be able to close it on her machine if I need to make an edit to it? Is there a way?
    Last edited by 6StringJazzer; 11-21-2019 at 10:24 AM. Reason: Moderator corrected typo in title
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,675

    Re: All others to Edit, but be able to kick them out.

    Is there one particular sheet on the workbook that she may be working on?
    If so, you can write a short macro that will start a timer as soon as the workbook is opened and then keep resetting it as long as there is some activity [i.e. selecting a cell].
    If there is no activity for a period of time [you pick how long] then the workbook would automatically save itself and close.
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    2,213

    Re: All others to Edit, but be able to kick them out.

    maybe the below as a starter for 10
    also consider adding display alerts =false, so it will just close.

    https://www.extendoffice.com/documen...nactivity.html

  4. #4
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2016 Office 365 64-Bit
    Posts
    3,419

    Re: Allow others to Edit, but be able to kick them out.

    I've tried the macro to close before, but on her desktop it failed. I guess I could try it again. is there any other way?

+ 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. Syntax help - kick off .exe with 2 arguments?
    By JP Romano in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2018, 02:29 PM
  2. When I see the answer I'll kick myself.
    By Stoobydoo in forum Excel General
    Replies: 4
    Last Post: 06-27-2017, 08:13 AM
  3. Need One Dropdown List to Kick off Another
    By Xbwalker in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-09-2015, 03:56 AM
  4. VBA to kick off audio or jpeg
    By JonathanB2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2014, 01:12 PM
  5. Use of 'on time' to kick inactive users
    By TKCZBW in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-16-2014, 03:40 AM
  6. if function for free kick times
    By molemeister in forum Excel General
    Replies: 4
    Last Post: 04-21-2010, 09:10 PM
  7. Kick Users Out of Sheet
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2007, 05:34 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