Consulting

Results 1 to 1 of 1

Thread: The number of users in the shared workbook

  1. #1
    VBAX Mentor
    Joined
    Dec 2008
    Posts
    404
    Location

    The number of users in the shared workbook

    How do I find out how many users have a shared workbook open, of course I know
    MsgBox "Number of Users: " & UBound(ThisWorkbook.UserStatus)
    Problem:
    How can I find out the number of users in a shared workbook in save mode? That is in the BeforeSave procedure. Because in this mode I get a 1004 error about a locked file.


    I have to an unusual save of file, where one of the necessary conditions (there are several) is the use of the file by one person.


    I attach a file showing the problem.

    Artik
    Attached Files Attached Files

Posting Permissions

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