Hello,
I have a spreadsheet that multiple people use and it has a button to access another spreadsheet. If that sheet is open by someone else and another user tries to open it, the macro opens it read-only and presents a message box stating that someone else is in the file and that they won't be able to save anything they do.
What I want to do is go more specific and actually say who is in the file so that the person trying to open it knows who is in it. I have tried 'Workbooks("xxxxx.xls").WriteReservedBy' but this always returns the name of the current user and not the user who is locked in the file.
Is this property held anywhere and how can I read it?
Thanks!
I have a spreadsheet that multiple people use and it has a button to access another spreadsheet. If that sheet is open by someone else and another user tries to open it, the macro opens it read-only and presents a message box stating that someone else is in the file and that they won't be able to save anything they do.
What I want to do is go more specific and actually say who is in the file so that the person trying to open it knows who is in it. I have tried 'Workbooks("xxxxx.xls").WriteReservedBy' but this always returns the name of the current user and not the user who is locked in the file.
Is this property held anywhere and how can I read it?
Thanks!
