Microsoft 365 and Office | Development | Other
Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
Look into ThisWorkbook.UserStatus
VBA Multi user information
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 30%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
David Kuruc
1
Reputation point
Hello,
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.
Microsoft 365 and Office | Development | Other
Developer technologies | Visual Basic for Applications
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
2 answers
Sort by: Most helpful
-
Bob Larson (Access MVP 2008, 2009, 2011) 251 Reputation points2021-07-06T01:16:09.69+00:00 -
David Kuruc 1 Reputation point
2021-07-06T10:01:00.887+00:00 Thank you for answer,
This method is great for names, but there is missing information about location where is active. And that is key information for me.
Sign in to comment -
-
Bob Larson (Access MVP 2008, 2009, 2011) 251 Reputation points
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.