Userform Login on userform and disabling/enabling userforms controls

Hi, I am trying to create an userform that promts the user to login and if the user enters the correct username and password the userform controls are enabled.

At the moment I am the only user so that I could use only password to login.

I want help with how to create the login and if the correct username/password OR the correct password is entered I want to enable all controls.

With controls I mean the multipage tabs. I would also like to logout and save all data from the userform into my spreadsheet and close/unload the userform.

userformhelp.png

Hi davesexcel,

thank you for your reply. I checked your link out and I am going to watch more of your videos.

I am trying to only have 1 userform but I like the suggestion to hide controls when the password isn't entered.