View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
EdMac
 
Posts: n/a
Default Protected sheet accepting values from List


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


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=512068