Who opened the file

  • Thread starter Thread starter Steven
  • Start date Start date
S

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
 
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
 
Back
Top