Is this even possible? Userform login - Change password userform box

I have a small app that uses a login system to allow different users access to certain sheets and makes all other sheets veryhidden, now I recently had one of the users come to me telling me they forgot their password and would like me to create a new one, now this is not a problem as I am down as the administrator and have access to all sheets but what I would like to do is create a small userform that enables the logged in user to request a new password, the userform must generate a random 6 digit number, populate it to a specific cell on the admin sheet then send them it in an email and/or show them it via a popup message box?

thanks guys,

Chris.

Olly, Thanks for the code, the only problem is that the password isn't your standard 'protect sheet' password, it is a userform login system that checks passwords in cell next to username on an admin sheet, if both match then the workbook opens and gives access to certain sheets based on which user logged in. I have uploaded a copy of the workbook to an online file uploader as it exceeds the 1mb limit. rest assured, the file is completely safe. http://www.filedropper.com/managementtestv1

Mikerickson, regarding the email security concerns. The workbook is stored on a secure network that only 10 people have access too, each with their own windows login and company email address. What I need is a userform that allows the user to select their workbook login name from a listbox on the reset password userform, the command button needs to generate a random 6-digit number and populate the cell next along from the username matched with the one selected on the reset password userform, it will also automatically send an email through outlook to a specific email address which will be determined by which name was selected on the listbox in the reset password userform. So say for example Matt Brown logs into windows, opens the workbook then instead of logging in he closes the login userform and presses the reset password button which in turn opens the reset password userform. Once Matt Brown selects his name from the listbox and pressed reset password the email will be sent to Matt Browns email address from his own email address. While typing this I have noticed the security issue, if say Ian selects Matt's name the email will still be sent to Matt but it will appear in Ian’s sent items therefor giving him Matt's new password! IS there anyway the email can automatically be deleted and deleted from the trash in outlook which prevents Ian from seeing the password? The department is pretty solid with no dicking around but still better to have all corners covered just in case.


FYI: All I have removed all company logos and set passwords to 1234. Login as username: Admin. Password: 1234