This is clever, you could use this to get users to link their name application.username to an email, then have them verify it by sending a temp password, removing the need for an admin to add new users. Could even run on startup if username don’t match table in hidden sheet
Hi John, that is a nice idea too. If it is a large application with lots of users and an admin wants users to be able to register, we could add a 'self-registration' certainly. Thanks so much for the comment and idea. Much appreciated.
Thanks so much Steve, next week we will be tabbing through cells AND shape based buttons. Most likely something you have not seen in Excel yet. Much appreciated.
This is really wonderful....You are an inventor....I greatly appreciate all your work.....Keep it up Randy....Thank you so much for this valuable video
Very good and Informative Video i am not able to download the project can you provide the link which work so its easy to us to download conveniently i have a question. beside Outlook can people receive Password Reset Key in gmail also not all have outlook account i am impressed with your video
Hi If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Hi and thanks for your comment. I have hundreds of programs and application so I am not sure which one you are referring to. My channel is a global channel however. I hope this helps and thanks so much.
@@ExcelForFreelancers if we link gmail account in outlook can we reset password using gmail in outlook i didnt understand that video u publish before gmail password reset Thanks
Great job as usually. I have a suggestion, why don't insert in the First User Form "LOGIN" a CheckBox and then disable and Enable it if the User is Authorized to change password. Sorry did not mean to be offensive.
Hi and thanks there are many ways that this can be updated for your own requirements. A nice suggestion indeed. Please feel free to download this and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, another great video, I love how your logic and easy to follow coding inspires others to accomplish what might otherwise seem a mammoth task. Well done 👍
Hi Randy ... thank you as always for the continuous inspirations and ideas that you come up with to teach us. Simply awesome. Suggestion or is the a way that when new passwords are generated, that is contains Upper, Lower, Alphanumeric & Special Characters. I ran this this thru password meter in terms of strength & complexity & it comes up very weak. I know you always surprise us with your talent and skills and once again thank you.
Hi Neren thanks so much. There are so many ways that developers can require specifications on passwords and I think that is really important. In Today's video we will focus on how users can reset their own passwords, without specifying required formats of those passwords. In future videos I will show you how to require specific formats for strong passwords for their users. Thanks again for your continued support and suggestions.
You are welcome Jon and so great to have you. IF you like this training please check out the original training for this application which allows users to share and sync their Excel applications from around the world: ruclips.net/video/aKV5seZmiBs/видео.html
Great video. If this function is used in the shared environment is there a risk that two or more people are trying to reset their passwords simultaneously or close together and the reset key won’t match by the time the first person tries to use it and reset their password?
Hi Jack, thanks for your comment. It should not be an issue if you run a 'Share & Sync macro' right before a new password is assigned, this way there would be no conflicts. Thanks for the great question.
Hi Randy, Thank you very much for your great videos. We really appreciate all the efforts you do for us as Excel and vba lovers. On yhr other hand, I have a question which is very important to me. My question is related to a previous video which was poart of today's one (How To Share and Sync Your Macro-Enabled Excel Workbook, from Scratch, With Anyone). Frankly speaking, I did not get the idea of sharing an Excel file which has many vba codes with others through a shared folder in One drive. Don't you think when putting any Excel file with vba in clouds the vba won't work. Please clarify this point which is very important to me. All the best, Thamer Excellent
Hi Thamer, thanks for your comment and I appreciate your concern. The reason it works so well is that each user has their OWN excel application. The application does not have to be in a shared folder. It works because ONLY the changed data goes in the shared folder. When data changes, each individual excel application is updated with the new data. I will be developing a large accounting application with this share & sync feature in our Mentorship Program starting this month, so for sure you will want to check that out as well.
Hi Eric, I often use a colon, however it is not always necessary in newer versions of Excel. (probably just an old habit) Thanks so much for your feedback, much appreciated.
Hi Eric-Jan, this can be removed, Sometimes i add colons, however semi-colons should not be used. I hope this helps and thanks for your feedback. I have made the necessary updates on the download version. Much appreciated.
Hi and thanks very much. It may be possible however I have not tried that method. If i get enough requests I can do research and add it in a future training if possible. I hope this helps and thanks so much.
HI Eric, thanks so much and glad you like it. In this video I will be showing you how to create an 8 character random security key, however I do not cover password encryption. The Admin sheet should always be 'xlVeryWellHidden' from non admin users when setting up your application.
Can this be use in google drive for office work? If not, how can I connect everyone (my office-mate) so that we can input data simultaneously if we don't have LAN? I might have some more questions along the way sir Randy, cause I'm a nurse and not and I.T. ;)
Hi Rex, thank you for your comment. The answer is Yes, you can use any shared folder including DropBox (which I think is the best), Google Drive, or Microsoft One Drive. Each user would need to have the shared folder software installed on their computer and each user would have to have shared access to this folder. Each user would have their OWN application and only the Data itself would be shared (not the excel file) There is a full training of how this would work here, however it does require vba skills, ruclips.net/video/aKV5seZmiBs/видео.html The application is open and you are welcome to customize this to fit your exact requirements, however, If you would like some help with this, we have a group with 20,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.
After you change the password for a user, close and safe the workbook and open it again to change the password again for the same or any other user, it is always the same key - SNPHHUAT. There is something wrong with the code. Can you post the correction? Thanks. Update: You forgot to put after For loop in module SendPWEmail.
Hi Randy... your email macro works only for Outlook. Many folks use gmail or something else.. So, would you not need to have something that would work for any kind of email. Seems I remember you had a routine that would always work..... just wondering why you don't use it instead or at least mention it.
how to reset password using Gmail like the steps in How To Create A Fully Automated User Password Reset In Excel video using gmail video it shows different method kindly make video of how to reset gmail also mention like this video done thanks
@@ExcelForFreelancers if I use outlook method if gmail users user that same steps Since you are professional can you try to make video based on non-outlook Not all people have outlook Thanks
Hello, I have a problem with excel vba.. I created a full excel macros vba file and program it to open/save all userforms automatically and hide excel file. I forgot to create a button to enter to excel worksheet file. There is a way to open this excel worksheet file to make more edits.? Thanks..
HI Amr, you should be able to open it without macros enabled and then use Alt + F11 to enter the VBA Editor to make changes. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
How can I make it to where the user is required to use the correct case? Right now, the user can login as long as the characters match...even if it doesn't match each upper or lower case for the password.
Hi Justin, thanks for your message. I will be creating a new training on password security and matching case very shortly so this should, however a simple value to value comparison will be case sensitive. You can find more details here: www.automateexcel.com/vba/case-sensitive/
Hi Santosh, thanks for your message. I have created a Facebook group with 23,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.
@@ExcelForFreelancers Sir, I have sorted out the bug and removed it...... Thanks Sir for your wonderful videos...I am unsatisfied.... because the more I see and learn from you I feel like I have to learned more from you...it become that I am addicted to your videos..... Keep Flowing Sir
In Outlook 2007 below code will be worked properly ? Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) With OutMail .to = Sheet2.Range("B13").Value 'Email Address .Subject = "Your Password Reset Key Is Here" .Body = "Hello " & Sheet2.Range("B11").Value & vbCrLf & _ "Please use the following password reset key to reset your password:" & vbCrLf & _ PWText & vbCrLf & "Thank you very much, Admin" .display '(You will want to change this to .Send) End With
Hi thanks this should work but please give it a try. If you run into any bugs or issues that you cannot figure out, please feel free to upload the details and screenshots in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 25,000 Members who would love to help you with this. Thanks so much.
😱 𝗨𝗡𝗕𝗘𝗟𝗜𝗘𝗩𝗔𝗕𝗟𝗘 𝟲𝟱% 𝗢𝗙𝗙 𝗧𝗛𝗜𝗦 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬! 👉 www.excelforfreelancers.com/BFSale2024_YTPinnedComm
millions thumbs up to the greatest VBA teacher on earth Randy. Thanks for the valuable lesson
For sure, you are very welcome Jojo. I am glad I could help and share
Mr. Austin. You are an Excel WIZARD!! Liked the random password generator logic. Very neat.
Thank you so very much, I really appreciate that.
Thank you sir❤️
That's what I was looking for
Amazing tutorial
🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
For sure, you are very welcome and I am happy I can help. Thank you for your Likes, Shares & Comments. It really helps.
Dear Randy, you are the best .
Thanks so much Karim, I really do appreciate that.
This is clever, you could use this to get users to link their name application.username to an email, then have them verify it by sending a temp password, removing the need for an admin to add new users. Could even run on startup if username don’t match table in hidden sheet
Hi John, that is a nice idea too. If it is a large application with lots of users and an admin wants users to be able to register, we could add a 'self-registration' certainly. Thanks so much for the comment and idea. Much appreciated.
Awesome Tutorials.....How do I combine multiple user log in with password reset.
HI and thanks Rar I have a video on multiple users in which you can use here: ruclips.net/video/0ahYoy5L3ec/видео.html
Another GREAT tutorial Randy. So many cool things to do with Excel. Look forward to Tuesdays!
Thanks so much Steve, next week we will be tabbing through cells AND shape based buttons. Most likely something you have not seen in Excel yet. Much appreciated.
This is really wonderful....You are an inventor....I greatly appreciate all your work.....Keep it up Randy....Thank you so much for this valuable video
Thank you so much Rohit, I am really glad you enjoyed the training
I love it!!! Thanks so much, Randy!!!
Thank you so very much, I really appreciate that Chris.
Thank you for your Likes, Shares & Comments. It really helps.
You always have new thought.
I have learned alot from your video.
Thank you very much. I do appreciate that.
Very good and Informative Video
i am not able to download the project can you provide the link which work so its easy to us to download conveniently
i have a question. beside Outlook can people receive Password Reset Key in gmail also
not all have outlook account
i am impressed with your video
Hi If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
@@ExcelForFreelancersI Got the File thanks
is your Program Internationally recognized just asking for my understanding only
Hi and thanks for your comment. I have hundreds of programs and application so I am not sure which one you are referring to. My channel is a global channel however. I hope this helps and thanks so much.
@@ExcelForFreelancers if we link gmail account in outlook can we reset password using gmail in outlook
i didnt understand that video u publish before gmail password reset
Thanks
Great job as usually. I have a suggestion, why don't insert in the First User Form "LOGIN" a CheckBox and then disable and Enable it if the User is Authorized to change password. Sorry did not mean to be offensive.
Hi and thanks there are many ways that this can be updated for your own requirements. A nice suggestion indeed. Please feel free to download this and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, another great video, I love how your logic and easy to follow coding inspires others to accomplish what might otherwise seem a mammoth task. Well done 👍
Thanks so much Peter, I am really glad you liked it.
Hi Randy ... thank you as always for the continuous inspirations and ideas that you come up with to teach us. Simply awesome. Suggestion or is the a way that when new passwords are generated, that is contains Upper, Lower, Alphanumeric & Special Characters. I ran this this thru password meter in terms of strength & complexity & it comes up very weak. I know you always surprise us with your talent and skills and once again thank you.
Hi Neren thanks so much. There are so many ways that developers can require specifications on passwords and I think that is really important. In Today's video we will focus on how users can reset their own passwords, without specifying required formats of those passwords. In future videos I will show you how to require specific formats for strong passwords for their users. Thanks again for your continued support and suggestions.
Thanks, Randy. New user here.
You are welcome Jon and so great to have you. IF you like this training please check out the original training for this application which allows users to share and sync their Excel applications from around the world: ruclips.net/video/aKV5seZmiBs/видео.html
Great video. If this function is used in the shared environment is there a risk that two or more people are trying to reset their passwords simultaneously or close together and the reset key won’t match by the time the first person tries to use it and reset their password?
Hi Jack, thanks for your comment. It should not be an issue if you run a 'Share & Sync macro' right before a new password is assigned, this way there would be no conflicts. Thanks for the great question.
Hi Randy,
Thank you very much for your great videos. We really appreciate all the efforts you do for us as Excel and vba lovers. On yhr other hand, I have a question which is very important to me. My question is related to a previous video which was poart of today's one (How To Share and Sync Your Macro-Enabled Excel Workbook, from Scratch, With Anyone). Frankly speaking, I did not get the idea of sharing an Excel file which has many vba codes with others through a shared folder in One drive. Don't you think when putting any Excel file with vba in clouds the vba won't work. Please clarify this point which is very important to me.
All the best,
Thamer
Excellent
Hi Thamer, thanks for your comment and I appreciate your concern. The reason it works so well is that each user has their OWN excel application. The application does not have to be in a shared folder. It works because ONLY the changed data goes in the shared folder. When data changes, each individual excel application is updated with the new data. I will be developing a large accounting application with this share & sync feature in our Mentorship Program starting this month, so for sure you will want to check that out as well.
Hi Randy, why is there a semicolon after Else: in the if...then...else construction. That wasn't necessary before if I'm not mistaken
Hi Eric, I often use a colon, however it is not always necessary in newer versions of Excel. (probably just an old habit) Thanks so much for your feedback, much appreciated.
Hi Eric-Jan, this can be removed, Sometimes i add colons, however semi-colons should not be used. I hope this helps and thanks for your feedback. I have made the necessary updates on the download version. Much appreciated.
Hi i m Momin from India, i m big fan of you. I love your hard work. Thank you.
Is it possible to send OTP instead of Mail
Hi and thanks very much. It may be possible however I have not tried that method. If i get enough requests I can do research and add it in a future training if possible.
I hope this helps and thanks so much.
Hi Randy, learning so much of Your videos. Thnx! Does this premiere cover encrypted passwords in the data sheet as well?
HI Eric, thanks so much and glad you like it. In this video I will be showing you how to create an 8 character random security key, however I do not cover password encryption. The Admin sheet should always be 'xlVeryWellHidden' from non admin users when setting up your application.
Awesome video. Thank you so much sir.
Thank you very much. I do appreciate that.
Thanks for this beautiful share.
Thank you so much Syed. I am glad you liked it.
Sir can you please teach how to put an licence key on Excel software same as any professional software which can be activated from our side
Hi thanks very much. I am teaching that in my Mentorship Program. You can find all of the details right here: bit.ly/MentorshipProgram_YTCom
Awesome video! Keep up the good work👌
Thank you very much. I do appreciate that.
Can this be use in google drive for office work? If not, how can I connect everyone (my office-mate) so that we can input data simultaneously if we don't have LAN? I might have some more questions along the way sir Randy, cause I'm a nurse and not and I.T. ;)
Hi Rex, thank you for your comment. The answer is Yes, you can use any shared folder including DropBox (which I think is the best), Google Drive, or Microsoft One Drive. Each user would need to have the shared folder software installed on their computer and each user would have to have shared access to this folder. Each user would have their OWN application and only the Data itself would be shared (not the excel file)
There is a full training of how this would work here, however it does require vba skills, ruclips.net/video/aKV5seZmiBs/видео.html
The application is open and you are welcome to customize this to fit your exact requirements, however, If you would like some help with this, we have a group with 20,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
I hope this helps and thanks so much.
After you change the password for a user, close and safe the workbook and open it again to change the password again for the same or any other user, it is always the same key - SNPHHUAT. There is something wrong with the code. Can you post the correction? Thanks.
Update: You forgot to put after For loop in module SendPWEmail.
HI and thanks so much. Running the macro on workbook open will take care of this. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Your work is really great.
Thank you so very much, I really appreciate that
Hi Randy... your email macro works only for Outlook. Many folks use gmail or something else.. So, would you not need to have something that would work for any kind of email. Seems I remember you had a routine that would always work..... just wondering why you don't use it instead or at least mention it.
Hi Glenn, thanks for your comment. I have an entire video on sending emails without outlook here: ruclips.net/video/WoCuRFEuACg/видео.html
Nice video
Thank you so very much, I really appreciate that Forhad
Nice, thanks...
Thank you very much. I am glad you enjoyed it.
how to reset password using Gmail like the steps in How To Create A Fully Automated User Password Reset In Excel video
using gmail video it shows different method
kindly make video of how to reset gmail also mention like this video done
thanks
Hi and thanks. i am really not sure as I have not tried that with Gmail.
@@ExcelForFreelancers if I use outlook method if gmail users user that same steps
Since you are professional can you try to make video based on non-outlook
Not all people have outlook
Thanks
Hi and thanks. I have that here: ruclips.net/video/WoCuRFEuACg/видео.html
Thank you for your Likes, Shares & Comments. It really helps.
Hello,
I have a problem with excel vba..
I created a full excel macros vba file and program it to open/save all userforms automatically and hide excel file.
I forgot to create a button to enter to excel worksheet file.
There is a way to open this excel worksheet file to make more edits.?
Thanks..
HI Amr, you should be able to open it without macros enabled and then use Alt + F11 to enter the VBA Editor to make changes. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
How can I make it to where the user is required to use the correct case? Right now, the user can login as long as the characters match...even if it doesn't match each upper or lower case for the password.
Hi Justin, thanks for your message. I will be creating a new training on password security and matching case very shortly so this should, however a simple value to value comparison will be case sensitive. You can find more details here: www.automateexcel.com/vba/case-sensitive/
Amazing
Thank you so very much, I really appreciate that.
Code for receiving password reset key in mail is creating an Error.... please help me to understand that
Hi Santosh, thanks for your message. I have created a Facebook group with 23,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.
@@ExcelForFreelancers Sir, I have sorted out the bug and removed it...... Thanks Sir for your wonderful videos...I am unsatisfied.... because the more I see and learn from you I feel like I have to learned more from you...it become that I am addicted to your videos..... Keep Flowing Sir
In Outlook 2007 below code will be worked properly ?
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
With OutMail
.to = Sheet2.Range("B13").Value 'Email Address
.Subject = "Your Password Reset Key Is Here"
.Body = "Hello " & Sheet2.Range("B11").Value & vbCrLf & _
"Please use the following password reset key to reset your password:" & vbCrLf & _
PWText & vbCrLf & "Thank you very much, Admin"
.display '(You will want to change this to .Send)
End With
Hi thanks this should work but please give it a try. If you run into any bugs or issues that you cannot figure out, please feel free to upload the details and screenshots in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 25,000 Members who would love to help you with this. Thanks so much.
Amazing not for for you this trick......
Thank you very much. I do appreciate that.