Use Windows Authentification to "sign" and "countersign"

[Lingim]

Hi All,
I have a situation where i need to have two users validate an entry in excel, basically a register of an event that is "signed" and then witnessed / countersigned.
Rather than creating and updating another login/passwords for everyone that will use this (200+) I want to use windows authentification for validation and enter the users name in the cell.
I want this for both entries as the workstation that they are entering it in may be logged into another user. eg user1 is logged in, and user2 and user3 to "sign".
I have some VBA skill but this has me stumped. thanks

 

[Tivakaran]

Hi. I dont know VBA but for username of the logged in user can be attained by using Environ("username") if not mistaken....its just I dont know how to put it in cell as permanent