#1   Report Post  
Antonio Guillen
 
Posts: n/a
Default 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?
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pick from a list Alicia Excel Worksheet Functions 2 July 31st 08 04:20 PM
Indexing items from a pick list Pank Mehta Excel Discussion (Misc queries) 1 February 3rd 05 10:29 AM
right click option "pick from a list" Landerson New Users to Excel 2 February 2nd 05 01:14 AM
Pick List Alex M Excel Discussion (Misc queries) 1 January 11th 05 02:30 PM
How do I pick a number from a list in Excel? pugsly8422 Excel Worksheet Functions 4 January 3rd 05 07:07 PM


All times are GMT +1. The time now is 12:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"