My department has a file that is on a public network drive. Periodically we need to make edits to the file, but someone else has it open read-write.
This file needs to be left unprotected because others do need to make edits to it.
We're looking for a way to determine the username of the person locking it. Not the username as it appears in Excel but the network login name of the user so that we can contact them and ask them to close the file if they are done with it.