View Single Post
  #1   Report Post  
Watson
 
Posts: n/a
Default Data Validation list boxes

Hi--
I have three columns which have data validation list boxes attached, so =
that=20
when you click on a cell a little handle appears and you select a name =
from=20
the list box that appears. In one of the columns, however (and always =
the=20
same one), the handle doesn't show up. When you to type in a cell, the=20
warning box still appears saying that you have to select data from the =
list,=20
but the handle never appears, making selection impossible.=20

Thinking the workbook was corrupt, I tried copying the whole sheet into =
a=20
new workbook, and the validation in the problem column did work for a=20
while, but now it's gone again. The other two validated columns continue =
to=20
work fine.

Help! Is my file just hopelessly corrupt? I'm running this on Mac OSX--
might that be connected to the instability? Any ideas would be much=20
appreciated.