I not sure if this will work for your problem but you might give it a
look. I added a macro to a button to clear all unlocked cells. You
might try it with your drop-down list.

The following link to view the macro:
http://www.mrexcel.com/archive2/58900/68299.htm

-nmrivera


--
nrivera
------------------------------------------------------------------------
nrivera's Profile: http://www.excelforum.com/member.php...o&userid=23448
View this thread: http://www.excelforum.com/showthread...hreadid=373927