Situation when file is "read only"

R

Robert Crandal

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub projects added as read only in Master file which are saved on sharepoint 1
Access Lock File .LACCDB / Now shows as a notepad file 0
Remove "read-only" from Publisher file 0
Why is file suddenly "Read Only"? 3
Open Add-In (.xla) workbook as Read Only automatically 1
Outlook 2010 can't find .pst file 1
Determine which user has write access to a file? 2
Determine who last modified an Excel file???? 5

Top