Pick list

A

Antonio Guillen

The content of a cell can be copy into a cell containing a pick list in a
Password protected sheet;
That shouldn't be; how can i prevent that?
 
E

Earl Kiosterud

Antonio,

If the sheet is protected (Tools - Protection - Protect sheet), then Pick
from list should be greyed in the right-click menu.
 
D

Debra Dalgleish

That's one of the weaknesses of data validation -- users can paste any
value into the cell, and overwrite the validate settings.

Perhaps you could use programming to validate the data.
 
E

Earl Kiosterud

Debra,

I guess when he said "containing a pick list," he meant a validation list,
as you've inferred. And you're probably right. I thought he meant using
Pick from list in the context (right-click) menu.
 
Top