Situation when file is "read only"
 

My workbook is used in a networked environment by
5 users. If one user opens the workbook, that workbook
will appear as "read only" to the remaining 4 users.

So, if one of the 4 users opens this file in "read only" mode,
I want to inform them who currently has write access
to the file. Are there any VBA functions which return
the username or user ID of the person who has current
access to the file??

Thank you!