Hi there,
I'm trying to have Excel autofill a cell with the 365 user's name who opened the workbook. This is a workbook with co-authoring off, so each person opens Read-Only. Many sites say use the =USER() or =USERNAME() function, but that simply doesn't exist. There was another about using VBA to pull the username but that turns out to return my windows login name (first initial, last name) which isn't what I'm looking for either. Does Excel allow you to autopopulate a cell with the name of the 365 user account the workbook instance is opened by?
Thanks
Brian
I don't remember USERNAME() or USER() to being a function in Excel; it's a Windows setting
You will probably have to use a macro to retrieve the ENVIRONMENT("USERNAME") or Application.User
