Identifying users in Excel VBA
I am building an excel file which I want to be used by up to 5 people, but which I do not want them to share <Tools><Share Workbook.> The reason for this is that I need to log each action with a unique identifier, which would not be possible if two people opened a shared workbook at the same time.
I have written an auto_open routine which will alert the user that they have not got the file read write, because another user is in it, and will then auto_close the file.
I would like to be able to show the second user, the log on id of the person who does have the file read write, presumably using some sort of environ("userna me") function. Does anyone know whether this is possible?
Thanks for your help.
EBG
I have written an auto_open routine which will alert the user that they have not got the file read write, because another user is in it, and will then auto_close the file.
I would like to be able to show the second user, the log on id of the person who does have the file read write, presumably using some sort of environ("userna me") function. Does anyone know whether this is possible?
Thanks for your help.
EBG