I see you got the Holmes reference. Sorry about the delay--I had to =
leave=20
the office for the day. The settings are=20
as follows:
ALLOW: List
DATA: between
SOURCE: =3D$AT$13:$AT$17 (These cells contain the items that should=20
appear on the list.)
IGNORE BLANK is checked
IN-CELL DROPDOWN is checked
SHOW INPUT MESSAGE is checked (but there is no message)
SHOW ERROR ALERT is checked
TITLE is Error Alert
STYLE is stop
ERROR MESSAGE (I won't bore you with the text--it's about 110 =
characters)

That's it--except for the source cells and error text, the settiings are =
the=20
same as for the others validations that work. Sigh. Any ideas?

-----Original Message-----
My dear Watson,

Tell us exactly what the Data - Validations settings are in one of the=20
errant cells are. Look in all three Data Validation tabs.

--=20
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Watson" wrote in message=20
...
Hi--
I have three columns which have data validation list boxes attached, so =

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

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


.