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