+ Reply to Thread
Results 1 to 2 of 2

Kick out Inactive users except in read only

  1. 07-17-2013, 01:34 PM #1
    StephanieLilly
    StephanieLilly is offline
    Registered User
    Join Date
    02-13-2013
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    17

    Kick out Inactive users except in read only

    I used the VBA from here http://www.excelforum.com/excel-prog...-workbook.html to kick out users when they were inactive. However, users do not need to be kicked out if they enter as read-only. Is there a way to code so that it only kicks out a user that is in edit mode?
    Reply With QuoteRegister To Reply
  2. 07-17-2013, 02:16 PM #2
    Lifesigns
    Lifesigns is offline
    Forum Contributor
    Join Date
    11-25-2010
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    120

    Re: Kick out Inactive users except in read only

    Hi,

    You just need to check if the workbook is opened read only. So replace this section of the code with:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Should do it.
    If the post was helpful please click the black star on the bottom left to add some reputation and mark your thread as SOLVED.

    A day with nothing new achieved or learned, albeit however small, is a day lost forever?

    Constant Never Ending Improvement
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. 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
  3. 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
  4. Kick Users Out of Sheet
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2007, 05:34 AM
  5. xp should allow home users to read excel
    By Chrisk in forum Excel General
    Replies: 3
    Last Post: 04-01-2006, 07:40 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1