Who opened the file
 

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

Who opened the file
 

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


"Steven" wrote in message
...
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