Restrict drop down list to a specific user

**cseahalign** · 10-21-2022, 06:41 AM

Hi, can anyone help with the below -

"Sheet 1" - I have set up data validation a drop down list on Column A named "Country" ; which feeds from the range list "Country" on Column H on Sheet 2.

"Sheet 2" - Under Column H "Country" range list i have these options
- Japan
- Australia
- China
- India

So if my username is "User001", I can only see "Australia" to select from the drop down list on Column A in Sheet 1.
And if my username is "User008", I can only see "Japan" to select from the drop down list on Column A in Sheet 1.
And for all other users, they can see all 4 countries to select from the drop down.

Thank you.

**BadlySpelledBuoy** · 10-21-2022, 12:02 PM

Hi and welcome

If using VBA is an option for you then something like the below open event could work.

Please Login or Register  to view this content.

It will check the current username when the file is opened and will allocate the available drop down values from there.

BSB

**cseahalign** · 10-26-2022, 05:10 AM

Yes it works!! Thank you so much, you are awesome

**AliGW** · 10-26-2022, 05:14 AM

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.