Hi,
I have a spreadsheet where I use a Validation List to select a user and insert an image associated with that user. I use the Validation List which has a name manager field with reference [=INDEX(Sheet1!$A$2:$B$6,MATCH(Sheet1!$E$2,Sheet1!$A$2:$A$6,0),2)] which has the names and images.
I would like to add a password protection to this as in \excel-general/744273-password-for-dropdown-list.html and have tried the solution from JBeaucaire but when I download the example solution, it does not work for me. I have enabled macros, and can see the macro within the file.
The end result of this would be that a user can select his image when entering his password, but nobody else's image, also users cannot be able to copy the images, after they appear in the spreadsheet.
Sample file shows List range A2:B4 and List dropdown at E2, with output to F2, although the source data may be on a different sheet in the final version.
Any Ideas what I am doing wrong?
Thanks
Bookmarks