Prev: Why is the font tab missing from Format Control box?
Next: Conditionally formatting text and numbers differently
From: Dave on 12 Jan 2010 19:34
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
From: Homey on 13 Jan 2010 06:51
check you have option to show objects turned on. in excel 2003 it in View
section of excel options.


"Dave" <Dave(a)discussions.microsoft.com> wrote in message
news:E9C6B055-DDE2-4FAF-94C1-638B39A861BE(a)microsoft.com...
|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

From: zvkmpw on 13 Jan 2010 16:36
> 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?
 | 
Pages: 1
Prev: Why is the font tab missing from Format Control box?
Next: Conditionally formatting text and numbers differently