Who has a workbook open
I have created a workbook that opens a second workbook for
people to enter data.
But if somone else already has this second workbook open
then my workbook opens a read-only copy.
I've got an if statement that prevents people entering
data to a read-only copy, but it would be great to display
the name/ID of the person who does have it open, as would
happen if a person has opened it directly and not via my
workbook.
TIA
|