Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Who is in a network shared Excel file
I retreived this code from a post and it works good as long as I am the one
who has it opened originally, but if someone else opens the file first, I have a 'read only' copy and this code gives me an error. Is there a way to modify this so I can see who has the Excel file open? Sub UsersList() Dim users, msg As String users = Workbooks("Logistics Repair Time Log.xls").UserStatus For Row = 1 To UBound(users, 1) msg = msg & users(Row, 1) Next MsgBox msg, 64 End Sub -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared workbook, on network, file lock | Excel Discussion (Misc queries) | |||
Edited links keep reverting when we save a shared network file. | Excel Discussion (Misc queries) | |||
Preventing Users From Locking a Shared Network Add-In File | Excel Programming | |||
Finding the Username of a user who has a shared Network file open. | Excel Programming | |||
Protect file on a shared Network drive | Excel Programming |