How do I find out how many users have a shared workbook open, of course I knowProblem:MsgBox "Number of Users: " & UBound(ThisWorkbook.UserStatus)
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