Hi,
I'm wanting to have selections available from a dropdown data validation list. But all the selections to have a different password. So you can only choose the ones you have a password for.
I don't wish to use vba code.
For example; My drop down items are Recipe Book 1, Recipe Book 2 etc. If someone has purchased recipe book 1 and not 2, I only want them to be able to select recipe book 1 (with a passcode). If they have purchased both books, then they will have two passcodes, and can then select both books. I have dependent drop down lists. And this aspect is working. I just wish to add a passcode to the options to select.
Thank you for your time.
I'm wanting to have selections available from a dropdown data validation list. But all the selections to have a different password. So you can only choose the ones you have a password for.
I don't wish to use vba code.
For example; My drop down items are Recipe Book 1, Recipe Book 2 etc. If someone has purchased recipe book 1 and not 2, I only want them to be able to select recipe book 1 (with a passcode). If they have purchased both books, then they will have two passcodes, and can then select both books. I have dependent drop down lists. And this aspect is working. I just wish to add a passcode to the options to select.
Thank you for your time.
