Show the Username of the Person who Opened A File as Read Only

Hi,

I need help with this item please.
I have already searched this forum if this has been asked in the past, but I cant seem to find anything. If in case I missed it, I apologize and kindly direct me to that thread.

If not, here is the item that I need help with.

We have a shared drive wherein everyone can access the files placed on that drive. All the files are password protected. Most often, we just open a file as read only and do what we have to do with that file. What I would want to know is that, what would be the VBA code wherein the file would say - through a Message Box - that the file has already been opened and it would show the username of that person who has opened the file in read only. The VBA should only work if someone has already opened the file as read only.

Thanks for the assistance.

I believe the point of Read-Only is that you do not modify the file, including it's properties. I believe you would be able to do this using Windows Audit Policy, but that is a bit off topic of this forum.

Hi Cebalaw,

Thanks for looking into this. However, I would like to differ.
There has been several discussions over the internet related to this task. They are just outdated that they no longer work on versions of excel from 2013 onwards, as to what I understand. That's why Im asking for help in this forum that maybe someone can provide me a VBA code that will work on newer versions of excel.
Thanks to that someone in advance

i think if someone can send you code for log activity for all user i think it can work