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
|