Excel - Data Validation Protection

[Salut39]

I Have a List of Items, I set up Data Validation with DropDown List and when I protect worksheet it allows to select from the list but if I lock cells it does not. I don't want to allow people to use copy/paste anything from other places but allow validation selection. Is there any way to do so?
The other thing with validation if you have a long list it will not drop alphabeticly when you start typing. Any suggestions?

Regards,
Yuri

 

[GlennUK]

How about using a combo-box instead? Debra Dalgleish explains how here:

http://www.contextures.com/xlDataVal10.html

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Salut39]

Thanks, I will look into it.