Provide way in VBA to know who, if anyone, is currently coauthoring a OneDrive/Office365 document
There are certain functions and events (only tested in Excel .xlsm desktop) that don't work when a document is in coauthor mode using OneDrive/Office365 syncing. If only one person is in the file, the macros work fine. If more than one are in it and co-authoring it would be good to know so certain macros can be prevented from running that otherwise cause the "Reload document" message on the computer that didn't run the macro.
Some of the VBA that doesn't work during coauthoring include all .FormatConditions code (even though you can manually add conditional formatting, doing it by VBA doesn't work). Adding or adjusting named ranges, repositioning notes, and using ThisWorkbook.Unprotect.
The is a solution for Word.
But I didn't find a solution for Excel
It is desirable for the administrator of a project to be able to determine who is currently using the project, particularly if the administrator wants to make changes. The administrator should also be able to post a message to all current users like "please log out within next 5 mins" and at the same time block any additional users from logging into the project.