I am trying to make a form for work that many different employees will have access to and have to sign off on certain tasks. I am able to make a drop down list with each employees name but want to be able to password protect each name so that when it is selected from the drop down list, you are prompted to provide a password before the selection can be made.

This old thread (link below) explains exactly what I'm trying to achieve however, I am not familiar with coding at all and after trying several times to use the code a user posted in the thread, I have not had success.

Can someone explain to me how to use the code in a macro? I tried to do a little research on coding in Excel, but with no luck. If someone could dumb this down for me and use the workbook in the original thread to explain, I would greatly appreciate it. Once I understand how it works, I'm confident I'll be able to apply it to my own workbooks.

/excel-general/744273-password-for-dropdown-list.html

Thanks!