VBA Multi user information

David Kuruc 1 Reputation point


I would like to ask, is there any commands or library for VBA to get information from multi-user excel status? (Maybe this is information from SharePoint, or teams. I'm mot sure)

More specific, I can see name and location where is active my college.

Is any way to get this information for VBA, so i can work with that in code?

Thank you

In picture, there you can see my name in top right and my location in green A4

My college is online, there is his name, and you can see his cell on C4 - color pink.


Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,214 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. 2021-07-06T01:16:09.69+00:00

    Look into ThisWorkbook.UserStatus


  2. 2021-07-06T14:11:56.017+00:00

    Well, that's about the only thing you have available to you unless you use VBA to add a custom property to the workbook and then update the property via VBA in the On Open and BeforeClose events. Unless someone else knows something I don't.