Protected sheet accepting values from List

[anandmr65]

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

 

[EdMac]

Check if the cell with the list in it is protected and when you protect
the sheet make sure you uncheck the box 'select locked cells'

Ed

 

[anandmr65]

Ed,

Thanks for the reply.

When I chosse the "Tools -> Protection->Protect Sheet" option I am not
getting the option suggested by you 'select locked cells'. Only getting
a small window with Objects/Scenarios & Contents to be checked.

The cells that have the lists have the Format -Cells -> Protection
->"Locked" option checked.

Please let me know if I have missed something.

Thanks & Regards
Anand

 

[EdMac]

Anand,

I am using Excel 2002, if yours is earlier version it may not be the
same.

When I go TOOLS > protection >protect sheet I have a box that contains
a checkbox at the top which should be checked and asks for password and
about 20 things that can/cannot be allowed including 'select locked
cells'.

If yours is not the same - I am not sure what the answer is - you may
need to post again to get another response.

Ed