View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steven steven is offline
external usenet poster
 
Posts: 389
Default 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