Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation and cell protection
I am trying to restrict the data that is allowed to be entered into a range of cells and have set up some drop down lists using data validation. The problem I'm running into is that if I protect the cells, I'm unable to make a selection from the drop down list. If I don't protect the cells, people (it's a shared file) copy data that is not in my drop down list from other cells and paste it into these restricted cells to bypass the error alert. Does anybody know how to have data validation and protect the cells? Also, this wasn't an issue in Excel 2000, but we just upgraded to 2002 and that's where I'm having the problems. Thanks. -- jerrystan ------------------------------------------------------------------------ jerrystan's Profile: http://www.excelforum.com/member.php...o&userid=28573 View this thread: http://www.excelforum.com/showthread...hreadid=503016 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
monitor cell that uses data validation list for change | Excel Discussion (Misc queries) | |||
Data Validation does not work when selecting another cell. | Excel Discussion (Misc queries) | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
how to add two data validation lists to a single cell? | Excel Worksheet Functions |