Kicking a user out

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Kicking a user out

  1. #1
    Board Regular
    Join Date
    Dec 2003
    Location
    UK
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Kicking a user out

     
    Hi all

    Is there anyway of being able to remove a user from a workbook. The problem is i have a user that have set their username as setup and have sat in one of my files for ages.

    Thanks

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Keaau, Hawaii
    Posts
    238
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Kicking a user out

    This may be what your trying to do.

    CODE FOLLOWS

    Private Sub Workbook_Open()
    If Application.UserName = "TheUsersNameGoesHere" Then
    ThisWorkbook.Saved = True
    ThisWorkbook.Close 'Close just this workbook
    Application.Quit 'Or quit EXCEL completly
    End If
    End Sub

    CODE ENDS

    Place this in the WorkBook Module of the workbook in question

    Yours in EXCELent Frustration

    KniteMare

  3. #3
    Board Regular
    Join Date
    Dec 2003
    Location
    UK
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Kicking a user out

    Thanks for your help, but the user is already in the file so its readonly! Fortunely i have a macro to log the users details so once the come out ill catch them out. Its just annoying in the mean time.

    thanks again.

  4. #4
    Board Regular
    Join Date
    Dec 2003
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Kicking a user out

      
    I'd also like to know how to do this if a workbook is read-only.
    To infinity and beyond

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com