Re: Who opened the file
- From: "Harald Staff" <nospam@xxxxxxxxxxx>
- Date: Tue, 17 Jun 2008 16:40:46 +0200
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" <Steven@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5B305E6A-767F-4E52-8FFB-86468C80464D@xxxxxxxxxxxxxxxx
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
.
- References:
- Who opened the file
- From: Steven
- Who opened the file
- Prev by Date: Re: Adding formulas to cells dependant on data in another cell.
- Next by Date: Problem with RegEx and matches
- Previous by thread: Who opened the file
- Next by thread: Problem with RegEx and matches
- Index(es):
Relevant Pages
|
