Theidea is that the login macro, when authentication succeeds, will call another macro that makes a connection to a database and calls a procedure that will populate the sheets, which I also have doubts about how to make, since it has to connect to a database.
The authentication process needs to read the information on a user form and be able to send it as a parameter to a procedure in SQL so that it returns whether the authentication was successful or not.
Actually, you could try to add login / password in a very hidden worksheet (VBA hidden) and hash the password of the user (provided that the hash can't be used as a password by itself).
The latter issue could be an interesting question.
3a8082e126