Dec 27 2019 04:12 AM
Hi,
I want to make data validation in Column E for that I have made a dynamic named range.
The dynamic named range has been given in data validation pop-up menu Source.
As required it is appearing the pull down menu.. but still the cell is allowing to key in information.
I wish the user to use the pull-down menu only and should not allow to key in information manually.
How can this be done? Can anybody helpme to understand where I had gone wrong.
Regards & thanks in advance
Sreekanth Pillai
Dec 27 2019 11:40 AM