Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected sheet accepting values from List
Hi, I have protected a workesheet. But the user is able to enter the values if selected from the lists(validation lists) and it does not allow any data entry if the user directly enters any value into the cell. Is there any way we can prevent the data entry into Protected worksheet from lists also? I am using excel 2000. Please revert. Thanks & Regards Anand -- anandmr65 ------------------------------------------------------------------------ anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728 View this thread: http://www.excelforum.com/showthread...hreadid=512068 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create an automatic complete list from existing data in the sheet | Excel Discussion (Misc queries) | |||
Can Excel calculate populate table using row/column values & calc's on other sheet? | Excel Discussion (Misc queries) | |||
Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
how to hide rows in a protected sheet | Excel Worksheet Functions | |||
Selecting data from a list based on entered values | Excel Discussion (Misc queries) |