Spreadsheet thinks the same user is logged in no matter who is

[cdwr0550]

I created a spreadsheet with a VBA form. All works the way it is suppose to, however if anyone already has it open it and someone else opens it a message to open in read only appears( as it is suppose to). Which is not the problem. The problem is it does not matter who is logged into it always says that I am logged it in even tho my computer is off.


I am curious to what would cause this and is there a way to fix it. It would be handy to know who the actual user is logged in

 

[eastrand]

How are you checking for the logged in user? If you're using a formula, you can only get the installed folder name which is "usually" the same as the logged in user. In VBA, you can pull enviromental variables which should give you the true logged in user.

 

[cdwr0550]

How are you checking for the logged in user? If you're using a formula, you can only get the installed folder name which is "usually" the same as the logged in user. In VBA, you can pull enviromental variables which should give you the true logged in user.

UserA (myprofile name)
UserB (other users profile name)

I am not using a formula. If userB is logged in and any other user tries to log in it says that userA has it locked for edting and to open it in read only.

This becomes a problem because if that person is currently logged in you have no way to know who is actually the user and notify them to exit the program