Build a VBA Login System for Excel

Downloadable File: www.teachexcel...
Full VBA Course: www.teachexcel...
This tutorial shows you how to make everything you need to build a fully functional login and logout system in Excel using VBA.
This login system allows you to:
- Login using a username and password.
- Manage multiple username/password combinations with ease.
- Stay logged-in (persistent login state).
- Setup easy-to-manage verification systems in Excel.
To build even more powerful VBA projects or further customize this one, checkout my full VBA Course: www.teachexcel...
#msexcel #vba #tutorial

[@wayneedmondson1065]

Great! Thanks for the detailed demonstration of how to create a login system. Thumbs up!!

[@TeachExcel]

You're very welcome Wayne! Thanks for the comment :)

[@asomya87]

It was interesting! Just started learning VBA for data analytics. Thank you!

[@ekkiwurm7874]

Hi Don, thank you very much for the fantastic video. So well explained!

[@TeachExcel]

Thanks Ekki! I'm glad you liked it :)

[@asimsiddiq475]

thanks for protecting our sheet tutorial.

[@TeachExcel]

You're welcome Asim!

[@jefersenboelijn30]

Nice lesson, well explained. Somebody know how I can hide multiple worksheets instead of just one? Thanks in advance

[@craigpelham1779]

Thank you so much for this tutorial. Do you have one that shows multiple worksheets?

[@mattmiddleton4341]

Would this work across a shared workbook where multiple users could view it at the same time?

[@abdulhamidalhaddadi2255]

Nice lesson, can I use PC UserName login instead of UserForm?

[@gamzekilagoz2997]

Hi Randy, i wonder can i use IP prorection for user login istead of cteating user name, ( I mean I want to prevent to open file except some computers ) thanks for help :)

[@wynandnawrattel2117]

Hi Don, Love your video's .I just can't get the SUB LOGIN() to work. I have checked my spelling over and over, When running the vba my form function is skipped and I'm automatically logged in. Can you assist me please.

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@eikky2]

@TeachExcel, i like this code it worked for a month now i am getting an error. Run time error 1004. Method visible of objective worksheet failed.

[@Kiyoshi_9606]

Can't I just ALT+F11 and unhide any hidden tabs you've got?

[@cancermind]

He used VeryHidden status instead of just hidden , so I would guess you can't if that's a thing

[@florisvanderleest7798]

I followed this video letter for letter, but sadly the Protected Action button always states that the user is logged out even though the Hidden form is visible. Any tips?

[@florisvanderleest7798]

When I saved the vba and the workbook as a macro-enabled excel workbook, the Protected Action promptly showed that I am logged in.

[@itsfaithlux]

This Tutorial helped me alot! Thx. i need this login system to update product lists in my company. I want my employees to log in so that i can see which employee has updated which article. if something can't be right, i know immediately who did what wrong. Example: | Article | Quantity | Last Update | Updated by | -------------------------------------------------------------------------- | Book | 2 | 12/15/22 | Michael | In the Example you can see that *"Updated by"* shows Michael.. and this is what i need.. I hope I could clarify what I need :D how does this work? would help me enormously, am also willing to pay for it! thanks :)