Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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? |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pick from a list | Excel Worksheet Functions | |||
Indexing items from a pick list | Excel Discussion (Misc queries) | |||
right click option "pick from a list" | New Users to Excel | |||
Pick List | Excel Discussion (Misc queries) | |||
How do I pick a number from a list in Excel? | Excel Worksheet Functions |