Drop-down password

Hello everybody,

I'm currently facing an issue with the Dropdown-lists.
I managed to allow that each requester in the dropdown list needs to type in there own password to be able to select there names.
But I want the whole sheet to be protected, until you select your name. After which you are allowed to fill in data in a selected area.

I used the following code:

Please Login or Register  to view this content.

Hope that someone can help me

With extra sheet with Users and there passwords, to be hide
and dynamic named range with users for the validation list

Please Login or Register  to view this content.

Kind regards
Leo

Hi Leo,

thank you so much for your help!
It works perfectly