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


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


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