A coworker has been working for several days creating an Excel template
which contains several tabs which have various drop-down menus in cells
created using Data Validation. He suddenly lost all the drop-down
widgets (the little arrow symbols) on one of the tabs. The data
validation is still in place. If he types in a value not on the
validation list he gets the error usualy error message. The widgets are
missing from all of the cells on that sheet that contained drop-downs,
but still appear on cells on other sheets where there are drop-down
data validation. Clearing data validation and recreating it doesn't
help. Any new drop-downs created on that sheet act the same (data
validation in place but no drop-down lists).

I'm at a lose as to what might have caused this and how to fix it. Any
suggestions? We much prefer to avoid having to recreate the sheet which
would take the better part of a day!

Thanks!


--
JanetW
------------------------------------------------------------------------
JanetW's Profile: http://www.excelforum.com/member.php...fo&userid=2104
View this thread: http://www.excelforum.com/showthread...hreadid=397924

Are you sure that the "In-cell dropdown" box is checked on the
ValidationSettings tab?

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=397924

Yup. All the drop-downs were working fine at one point. And he suddenly
noticed that none of them were working any more!


--
JanetW
------------------------------------------------------------------------
JanetW's Profile: http://www.excelforum.com/member.php...fo&userid=2104
View this thread: http://www.excelforum.com/showthread...hreadid=397924

You can also try:

<Tools <Options <View tab,

And, under "Objects",
Make sure
"Show All"
*IS* checked.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"JanetW" wrote in
message ...

Yup. All the drop-downs were working fine at one point. And he suddenly
noticed that none of them were working any more!


--
JanetW
------------------------------------------------------------------------
JanetW's Profile:
http://www.excelforum.com/member.php...fo&userid=2104
View this thread: http://www.excelforum.com/showthread...hreadid=397924

Nope, no joy. We've resorted to just recreating the sheet from scratch.
Thanks everyone for your suggestions.


--
JanetW
------------------------------------------------------------------------
JanetW's Profile: http://www.excelforum.com/member.php...fo&userid=2104
View this thread: http://www.excelforum.com/showthread...hreadid=397924