View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Michael Michael is offline
external usenet poster
 
Posts: 791
Default Help! Drop down list problems.

Select all the cells with data validation and from the main menu select:
Format - Cells
In the Protection tab, remove the check mark from the Locked box, and then
proceed to protect your workbook or worksheet.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"JRThomas" wrote:

Hi. I am having trouble with a drop-down list that I have had set up for
some time. I have validation set up to allow only items from a list to be
chosen for certain cells and all of the little arrows at the lower corner of
the cells no longer appear like they did in the past. The value entered in
the cell must still match the list, but the list doesn't show up. The only
thing I have done to this worksheet lately is a password protection. Could
this be the problem and why? How can I get around the problem if it is the
protection?

Thanks in advance for your help!