VBA userform login to open excel using domain username and password

[Globaltechpharm]

Hello friends,

I need the code for VBA userform login to open excel using domain username and password.

So, when user open a file, userform will be activated and user need to enter username and password, domain name will be automatically detected and written in 3rd line. But if user need to enter other domain, he can enter in text box.

After that, when user clicks on command button to login, excel will verify domain username and password and if is correct then only userform will be closed. And user can do work in excel.

Such entry of login should be tracked on another worksheet "audit trail".

Hope that you understood my query.

Thanks for readin. Thank you in advance.

 

[Kamolga]

You should block the folder in your domain to certain users and use track change.

What I mean is that simply pressing shift while the file opens will bypass the userform and get anyone in the file

In addition getting excel to check userform/domain passwords is I believe a serious threat to your domain (i think I would find a way to print all usernames with password if I was a user).