Hi,
I have a vba code found on a previous thread which adds passwords to a drop down list, (Link to original post is included below). The vba works really well with my project with the drop down on sheet 1 and the passwords on sheet 2. Can this vba be used to handle multiply drop downs on sheet 1 sourcing from the same data on sheet 2 ??
I've tried to adapt the vba code myself but have very limited skills when coding and no surprise nothing but errors.
Any help would be greatly appreciated.
www.mrexcel.com
I have a vba code found on a previous thread which adds passwords to a drop down list, (Link to original post is included below). The vba works really well with my project with the drop down on sheet 1 and the passwords on sheet 2. Can this vba be used to handle multiply drop downs on sheet 1 sourcing from the same data on sheet 2 ??
I've tried to adapt the vba code myself but have very limited skills when coding and no surprise nothing but errors.
Any help would be greatly appreciated.
![www.mrexcel.com](https://www.mrexcel.com/board/styles/mrexcel/mrexcel-logo-og.png)
vba to request a password for dropdown list entries
Hi, I'm looking for a macro/vba that will require a user to enter a password before they can enter a selection from a dropdown list. In the example below the range C5:C10 is named 'Fruit'. The dropdowns to select from the range 'Fruit' are located in G5:G8 but ultimately may end up on another...