Disappearing drop-down widget

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!

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

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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.