Artik
09-09-2019, 03:34 PM
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
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