I have a workbook with twenty sheets. I have drop down menus on most of
them and can create more, except on one sheet where the drop down won't
function. On checking the cell it shows that the cell has a data
validation setting and that the list is correctly identified. But no
arrow or drop down shows.

I assume there is some setting somewhere preventing it but I can't find
anything different about this sheet. I've tried copying and pasting from
another sheet but no difference.

Any ideas? It's driving me crazy!

Thanks


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=493915