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 :)
Best simple one I have seen. Had so many that the code didn't work.
Great! Thanks for the detailed demonstration of how to create a login system. Thumbs up!!
You're very welcome Wayne! Thanks for the comment :)
It was interesting! Just started learning VBA for data analytics. Thank you!
Thank you so much for this tutorial. Do you have one that shows multiple worksheets?
Would this work across a shared workbook where multiple users could view it at the same time?
Hi Don, thank you very much for the fantastic video. So well explained!
Thanks Ekki! I'm glad you liked it :)
Nice lesson, can I use PC UserName login instead of UserForm?
Nice lesson, well explained. Somebody know how I can hide multiple worksheets instead of just one?
Thanks in advance
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 :)
thanks for protecting our sheet tutorial.
You're welcome Asim!
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?
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
Thanks for the share.
@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 :)