Click a cell that has the validation in it, go to DataValidation you
should see a checkbox called In-Cell Dropdown make sure its checked,
failing that rename your worksheet, create another with the name of the
original copy the values and formulae over then re-apply your
validation.


--
The Code Cage Team

Regards,
The Code Cage Team
www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=7264