The full question was posted elsewhere:
In summary, I want to make Excel check who clicked on a checkbox, and then return that user's name for use. The file has Co-authoring enabled and is uploaded to a SharePoint. I've tried 3 methods to get this information, none of which quite worked:
UserName = Environ$("UserName")
UserName = Application.Username
UserName = ActiveWorkbook.BuiltinDocumentProperties("Last Author")
They all seem to be determined partially based on who saved the document last. I made a work around, but now determining who is currently accessing a file is something that's relevant for another task I'm trying to automate. Does anyone have anything else I can try?
