I can successfully create drop boxes via validation in all shhets except one
ina workbook. The validation works but the drop down box does not appear.
The format of the sheet appears the same as the others, any ideas please.
Regards
Duncan

The Data Validation dialog Settings tab has a check box for "In-cell dropdown"
Has that got unchecked on the problem sheet?

BrianH

"Duncan, UK" wrote:

I can successfully create drop boxes via validation in all shhets except one
ina workbook. The validation works but the drop down box does not appear.
The format of the sheet appears the same as the others, any ideas please.
Regards
Duncan

Thanks, but no it is checked. Weird I have got round it by copying the sheet
contents into a new sheet, but then ad to re-do the linkages which was what I
was trying to avoid. In my workbook I have 15 sheets with dropdowns, all
sheets are fine excpet this one. I presume it is a page format issue, but I
cannot see any difference between the sheets

Duncan


"BrianH" wrote:

The Data Validation dialog Settings tab has a check box for "In-cell dropdown"
Has that got unchecked on the problem sheet?

BrianH

"Duncan, UK" wrote:

I can successfully create drop boxes via validation in all shhets except one
ina workbook. The validation works but the drop down box does not appear.
The format of the sheet appears the same as the others, any ideas please.
Regards
Duncan