ExcelBanter - Data Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Data Validation (https://www.excelbanter.com/excel-programming/420987-data-validation.html)

I have data validation on two sheets in a single workbook. On one sheet, the
data validation dropdown does not appear when the cell is clicked. However,
on the second sheet the drop down appears. I have checked the incell dropdown
option. How can I solve this? Thanks for your help.

See Debra Dalgleish's site for possible problems and solutions.

http://www.contextures.on.ca/xlDataV...rowsNotVisible

Since you can see the dropwdown on one sheet but not the other, I would tend
to rule out the "hidden objects" because that is a Workbook setting,. not
just a sheet or window setting.

Gord Dibben MS Excel MVP

On Mon, 8 Dec 2008 09:28:11 -0800, Jamal
wrote:

I have data validation on two sheets in a single workbook. On one sheet, the
data validation dropdown does not appear when the cell is clicked. However,
on the second sheet the drop down appears. I have checked the incell dropdown
option. How can I solve this? Thanks for your help.