Password Protection of Single Dropdown options

Hi All,

I am new to this thread but found some super useful info already regarding specific topic I am after, just not on a scalable way.

I have a drop down menu that needs each option password protected which I am able to do using a macro, however the bigger issue comes as this drop down has c.5000 entries in and each needs its own unique password. Without writing thousands of lines in the macro does anybody know how I would go about making the macro look up against a (hidden and password protected) sheet of data that has the drop down option and then the password next to it?

Hopefully this makes sense....

Thanks in advance!
Sam.

Originally Posted by Richard Buttrey

Hi,

The obvious solution would be a VLOOKUP(). Either in a hidden cell somewhere and compare the password given with that hidden cell, or as code in an

Please Login or Register  to view this content.

OK thanks, I am fairly new to Macros and wasn't aware I could do that! I will give it a go and see what happens!

Thanks.

Originally Posted by TMS

You could just use VLOOKUP. The password sheet doesn't need to be visible or unprotected to return the relevant password. So you just need a means of requesting the password from the user.

However, you need to be aware that Excel is not a secure environment and it would be a simple matter to access the password list.

Regards, TMS

Thanks for the quick response. I was going to use code similar to the code that I have picked up from this thread http://www.excelforum.com/l/744273-asdf.html and then adapt as required.

I am not overly concerned about data being accessed, there are only so many lengths one can go to. If people really want the data then they have another way of accessing it, I am just providing a simple solution for quick access to data they are allowed access to.

thanks