VBA GetUserName

I have the following code to get user name. I don't know how to add user name to one cell and have it locked and add another user name in another cell and have it locked when they open it to verify. Is it possible?

Please Login or Register  to view this content.

Hi Kinez,

I am not sure if I really understood, what you need. Still I have modified your macro to get it working, and hopefully help you understand what it does:

Please Login or Register  to view this content.

Do you want to use the username to check if a particular user is allowed to open a file? If yes we would simply need to call the function from the Workbook Open Macro. Let me know if that's what you want, and if you need my (or other Forum members) help on this.

Regards

Theo

I'm not sure what you are doing but this might help