Is there any circumstances when a Data Validation Drop down Tab will not
display, other than having the 'In-cell dropdown' unselected?

Hi
I heard from some 'corrupted' files esp. with Excel 97 (even had this some
time on my own). Easiest solution: Re-build the sheet

"John" wrote:

Is there any circumstances when a Data Validation Drop down Tab will not
display, other than having the 'In-cell dropdown' unselected?

Saw posting on the Group on XL97 with Freeze frames etc, I'm on XL2002, I
just recreated the whole sheet and it worked fine

Thanks


"Frank Kabel" wrote in message
...
Hi
I heard from some 'corrupted' files esp. with Excel 97 (even had this some
time on my own). Easiest solution: Re-build the sheet

"John" wrote:

Is there any circumstances when a Data Validation Drop down Tab will not
display, other than having the 'In-cell dropdown' unselected?

i have had the same problem as you regarding the dropdown tab showing. I'm on
XL2003. The only thing I can do is to copy entire data in the worksheet
having the problen to another worksheet, re-establish the links to my model
and then it works normally.

"John" wrote:

Saw posting on the Group on XL97 with Freeze frames etc, I'm on XL2002, I
just recreated the whole sheet and it worked fine

Thanks


"Frank Kabel" wrote in message
...
Hi
I heard from some 'corrupted' files esp. with Excel 97 (even had this some
time on my own). Easiest solution: Re-build the sheet

"John" wrote:

Is there any circumstances when a Data Validation Drop down Tab will not
display, other than having the 'In-cell dropdown' unselected?

The dropdown won't show if objects are hidden.

To show them, choose ToolsOptions
On the View tab, for Objects, choose Show All, or Show Placeholders

John wrote:
Is there any circumstances when a Data Validation Drop down Tab will not
display, other than having the 'In-cell dropdown' unselected?





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

It doesn't work though I've done as suggested.

"Debra Dalgleish" wrote:

The dropdown won't show if objects are hidden.

To show them, choose ToolsOptions
On the View tab, for Objects, choose Show All, or Show Placeholders

John wrote:
Is there any circumstances when a Data Validation Drop down Tab will not
display, other than having the 'In-cell dropdown' unselected?





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html