Pick list
 

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?

Antonio,

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

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Antonio Guillen" <Antonio wrote in
message ...
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?

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.

Antonio Guillen wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Debra Dalgleish" wrote in message
...
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.

Antonio Guillen wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html