Who opened the file

[Steven]

I have the following code on the Auto_Open because people have complained
that they need an additional reminder as they go into the file. They just
bypass the first one without thinking.

If ActiveWorkbook.ReadOnly = True Then MsgBox "File in use, it has been
opened Read Only."

Is there a way after the file is open to return which user has the file open?

Thank you,

Steven

 

[Harald Staff]

Hi Steven

There is a WriteReservedTo property you can test for this. Whether it works
or not is "depending on the network".

HTH. Best wishes Harald