| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| code to check file size everytime an Excel file is opened | Excel Programming | |||
| Determine if XL file opened from Outlook or a saved file | Excel Programming | |||
| stop excel file opened as read only if already opened by another u | Excel Programming | |||
| Close file and run macro from newly opened file | Excel Programming | |||
| How set file open path to filepath of file opened with Explorer ? | Excel Programming | |||
Linear Mode
