I have a validation with drop down list in it but the drop down is not
showing. I can go into the cells with the validation and it shows that it is
set up to be a validation with list. The source of the list is correct. The
drop down worked at one point but now it doesn't. Did I format the cells in
a way that does not allow for validations with lists?

Any help is appreciated. I have been fighting with this off and on all day.
Thanks

check you have option to show objects turned on. in excel 2003 it in View
section of excel options.


"Dave" <(E-Mail Removed)> wrote in message
news:E9C6B055-DDE2-4FAF-94C1-(E-Mail Removed)...
|I have a validation with drop down list in it but the drop down is not
| showing. I can go into the cells with the validation and it shows that it
is
| set up to be a validation with list. The source of the list is correct.
The
| drop down worked at one point but now it doesn't. Did I format the cells
in
| a way that does not allow for validations with lists?
|
| Any help is appreciated. I have been fighting with this off and on all
day.
| Thanks

> check you have option to show objects turned on. in excel 2003 it in View
> section of excel options.

I have the same problem with a particular workbook, but not with
others. It's Excel 2003.

For View>Objects, "show all" is selected.

Under Data>Validation, "In-cell drop-down" is selected.

Anything else that should be examined to bypass the problem?