View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default 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!