| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find out if a sheet is open by another user
Is there a way to find out in VBA if an xls is open in read/write mode by
someone and who that someone is. Many thanks, Dan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find out if a sheet is open by another user
See the UserStatus Property in VBA Help
-- Gary''s Student - gsnu200790 "Dan" wrote: Is there a way to find out in VBA if an xls is open in read/write mode by someone and who that someone is. Many thanks, Dan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find out if a sheet is open by another user
UserStatus does not work on a read only file - and I am interested to find
out who is the user that is locking the file, so that does not help me. on the help file it is written: "Remarks The UserStatus property doesn't return information about users who have the specified workbook open as read-only." Thank you. "Gary''s Student" wrote: See the UserStatus Property in VBA Help -- Gary''s Student - gsnu200790 "Dan" wrote: Is there a way to find out in VBA if an xls is open in read/write mode by someone and who that someone is. Many thanks, Dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does a Multi-sheet/user file open on sheet two every time? | Excel Discussion (Misc queries) | |||
| why, when i open a work sheet does a blank sheet open as well | Excel Discussion (Misc queries) | |||
| Open workbook macro- find correct month to open? | Excel Programming | |||
| How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
| Find and Open Workbook then copy and move sheet | Excel Programming | |||
Linear Mode
