No dropdown arrow

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

This is something I have never see before:

I am trying to help another OP with a Data Validation problem. I am familiar
(or so I thought) with the usual causes that prevent data validation from
working. In this case, Data Validation works as expected, except NO MATTER
WHAT WE DO, no dropdown arrow will appear when you click in the cell. The
In-Cell Dropdown box is checked, Freeze Panes is not invoked, there are no
macros, and no virus. If I create a new ws in the same wb everything,
including the dropdown arrow, works as expected in the newly created sheet.
If I copy the problem sheet to a new wb or to an existing wb, the dropdown
still will not appear in the problem sheet or the copy of it.

Looking at the properties of the sheet in the VBE yields no clues, as the
settings are the same as my other files.

Anyone seen this before? Did you find a solution?

TIA
 
Are objects visible?
Choose Tools>Options, View tab,
Under Objects, select Show All or Show Placeholders.
 
I have tried both Show all and Shoew placeholders; it makes no difference.
Although it would be easiest just to create a new worksheet, this has become
a challenge! I want to know what causes this behavior and prevents the code
in the Worksheet_Activate event from being effective.
 
Using Data Validation in cells that are merged has caused flaky
behaviour in some versions.
 
Hi,

I have the same problem as Jim describes. My panes are unfrozen, n
cells are merged, but I still don't see the drop-down arrow.

Has anyone found a solution yet
 
Do you have Objects displayed?
(Tools>Options, View tab -- under Options, choose 'Show All')
 
Yes, my Objects are visible. It worked originally, but then I copied th
ws to another wb and saved it. If I go to a cell where the Dat
Validation should be (and it was in the previous wb), I can go to Dat
--> Validation and the Settings are correct. In the cell, I can choos
Pick from List from the right-mouse-menu, and the right options ar
there. But still, no drop-down arrow.

As Jim already wrote, it's no big deal, because I can easily create
new ws and the Validation Data, but I just can't stand that there's
probem I can't solve. :mad:

Perhaps it's a bug
 
Back
Top