Solved: Show current users on userform

[parisoke]

Dears Friends,
I have one share workbook for multi users on different computers. I want to show on userform the number of current users of this file to notice others users (I make Application.visible=false).
Please help me how to do this?
Thank you very much!

[mikerickson]

Have you looked at the .UserStatus property? This will show you the number of people currently using a shared Workbook.
MsgBox Ubound(ThisWorkbook.UserStatus, 1)

[parisoke]

I'll try your code. One more question, where can I look the .Userstatus property?
Thank you very much!