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.
Bookmarks