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 :)
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.
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?
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 :)
Great! Thanks for the detailed demonstration of how to create a login system. Thumbs up!!
You're very welcome Wayne! Thanks for the comment :)
Best simple one I have seen. Had so many that the code didn't work.
It was interesting! Just started learning VBA for data analytics. Thank you!
Hi Don, thank you very much for the fantastic video. So well explained!
Thanks Ekki! I'm glad you liked it :)
Thank you so much for this tutorial. Do you have one that shows multiple worksheets?
thanks for protecting our sheet tutorial.
You're welcome Asim!
Nice lesson, can I use PC UserName login instead of UserForm?
Would this work across a shared workbook where multiple users could view it at the same time?
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 :)
Nice lesson, well explained. Somebody know how I can hide multiple worksheets instead of just one?
Thanks in advance
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.
Thanks for the share.
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?
When I saved the vba and the workbook as a macro-enabled excel workbook, the Protected Action promptly showed that I am logged in.
Can't I just ALT+F11 and unhide any hidden tabs you've got?
He used VeryHidden status instead of just hidden , so I would guess you can't if that's a thing
@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.
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 :)