pick list and Data Validation

[Makelei]

Hi,
Is there a way how to get sheet that has been filled with "Pick from
drp-Down list" method to be updated in a way that it would be possible to use
Data Validation?

BR
makelei

 

[Eduardo]

Hi,
Take a look at Debra webpage
http://www.contextures.com/xlDataVal02.html#TwoWord

 

[Makelei]

Thanks Eduardo,
I have used these featurea often and are working just fine.

My problem is that someone has started to update the table with mouse right
click using "Pick From Drop-down List". Now when this is used it will disable
visibility of data validation feature. Actually you are able to define it,
but when cell is activated, arrow and list will not be visible.

This is the very first time I have come agross this and do not know how to
return back and get this data validation to work as it should.

BR
Makelei